Very new beginner here.

This is what I currently have:

Date Past 3 years: IIf([date]<Date()-1095,"Greater Than 3 Years","Less Than 3 Years"

for records where the date has been left blank it puts "Greater than 3 Years". I would like for it to say "no date entered".

The original field is set to date format.

any help would be greatly appreciated.

Thanks!

C

First avoid naming fields the same name a reserved words. Using date as a field name will cause you many headaches.

To accurately get three years from a date use the DateAdd(). This will properly handle leap years. It will add or subtract from a date.


Example for subtracting three years:
To test for a date in a date/time field use IsDate()

Example:

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015