Number coverting to days

[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

 

[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

 

[Dirk Goldgar]

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

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)