Between DTPicker0 and DTPicker2

[Guest]

How do I get the present date using DTPicker? I want to see all transactions
for today, 2/13/07, so I'm using Between 2/13/07 and 2/13/07 in my form that
feeds a query.

Why do I have to do 02/12/07 to /02/13/07 to get today's date and how can I
fix that problem?

 

[Douglas J. Steele]

You sure you're using Between 02/12/07 And 02/13/07 to get records for Feb.
13th, or are you using Between 02/13/07 And 02/14/07?

The latter would make sense if the date field you're comparing against also
includes time (eg. you've used the Now function to populate it).

The former doesn't make sense at all to me.