Number coverting to days

B

Brandon Brewer

I was wondering if theres a way to convert a number to an amount of days so that I can test for say 30 days in advance
 
R

Rick B

Convert a number to an amoutn of days? What type of number?

Do you mean that you have a number suchs as 10 that you wish to add to the
current date? Is this number in a table, or do you request it from the
user?



I was wondering if theres a way to convert a number to an amount of days so
that I can test for say 30 days in advance
 
D

Dirk Goldgar

Brandon Brewer said:
I was wondering if theres a way to convert a number to an amount of
days so that I can test for say 30 days in advance
Click to expand...

The DateAdd function can be used to add a specified number of "date
units" to a date. So, for example, you can calculate a date that is 30
days from the current date by the expression

DateAdd("d", 30, Date)
 
Top