Number coverting to days

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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

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)
 
Back
Top