DATE QUERY

[amanda.redetzke]

I need to know how to create a formula that will return results for
anything that is 365 days out. The format of the date is mm/dd/yyyy.

 

[WatkinsMan]

try the DateAdd function. Something like this

Select * from tablename
where tablename.date <= DateAdd("d",365,Now())

 

[amanda.redetzke]

Thanks that worked.

try the DateAdd function. Something like this

Select * from tablename
where tablename.date <= DateAdd("d",365,Now())

 

[John Vinson]

I need to know how to create a formula that will return results for
anything that is 365 days out. The format of the date is mm/dd/yyyy.

THe format is irrelevant - a date is stored just as a number, a count
of days (and fractions of a day, times) since an arbitrary start
point.

To find all records where the date field contains a value greater than
one year (366 days in leap years) in the future, use a criterion

= DateAdd("yyyy", 1, Date())

John W. Vinson[MVP]