Hi
I have a date/time field ( "DateAdded") on a data entry form and want the recordset of that form to only show the current day's records. IF I set the query criteria for the forms record source to:
>=#17/03/2012#
(today being that date), I get today's records. That's what I want but don't want to create a parameter query asking for that date every time the form closes/opens during the day.
Date()
returns no results and I'm wondering if it has to time with the time component.
>Date()-1
Returns yesterday's and todays records.
Is there a simple date function that will work here?
Thanks for your time.