Accessing the Current Date

[Delboy14]

(Access 2002)
Is there anyway to access the current date in Access, I would like to put the current date into a field value in a query.

e.g. Select Name, Address, StartDate, Date
From Details
Where Date := Current Date

I would then like to select the records whose start date is 3 months or greater than the current date.

Does anyone know how to acces the current date, through the system clock or some other method, as I think I can do the rest, thankyou for any help

 

[Guest_imported]

try now().

 

[JoeMiller]

Use Date() instead of Now(). Now() returns the date and time, Date() returns just the Date, and I bet you can't guess what Time() returns! ;-)

HTH Joe Miller
joe.miller@flotech.net

 

[Delboy14]

a rolex?