Dates and NOW() statement

[Luddite Lad]

I want to compare a date in the form DD/MM/YYYY with the NOW() statement to see if they are the same however the NOW() statement returns DD/MM/YYYY HH:MM:SS

How do I restrict the NOW() statement to return just the date, as I'm not interested in the time.

 

[WayneRyan]

LL,

Use the "Date" function instead.

In VBA: Me.SomeDateField = Date

In Queries: NewField: Date()

Wayne

 

[Luddite Lad]

Thanks just what I was looking for

 

[ghudson]

= Format([YourDateField],"mm/dd/yyyy") will work if you have to work with an existing date field.