Dates in a query

[digitallifeform]

Hi all. This is my first visit...

I am creating a query at the moment which is to be run everyday fo
reporting. I dont want to go in and change the date it reports o
everyday....

Is there a way i can get it to report on "today's date" when it runs?

What is the criteria expression i would need to put in.

Many thanks

digita

 

[roger111]

If you are using that query for a report or a form, the answer is easy
just add a field to the form and set the datasource to "=now()
(without the quotes) and format to a format of your choosing from th
dropdown list. Today's date, provided that it is correct in th
computer clock, will print/show up on the screen.

Roge

 

[Pat Hartman]

=Date() would be a better choice since Now() includes time of day and will
interfere with finding correct records.