Short date report prompts for long date results

[Guest]

I am trying to set up a report where users can enter a short date prompt that
will return all data for a single day, regardless of the long date time
stamp. The table date formats cannot be altered. I existing prompt requires
the user to enter the exact long date match and not all records have the same
time stamp.
Thanks

 

[John W. Vinson]

I am trying to set up a report where users can enter a short date prompt that
will return all data for a single day, regardless of the long date time
stamp. The table date formats cannot be altered. I existing prompt requires
the user to enter the exact long date match and not all records have the same
time stamp.
Thanks

The Format of the fields is irrelevant: it just controls how the field is
*displayed*, not what's stored or searched.

You can use a criterion of

= [Enter date:] AND < DateAdd("d", 1, [Enter date:])

to cover the range from midnight at the beginning of the day to
11:59:59.9999999 pm.

John W. Vinson [MVP]

 

[Guest]

John, your suggestion worked great, I would have replied sooner but was on
vacation. Thanks for your help.
--
kuslusr1

I am trying to set up a report where users can enter a short date prompt that
will return all data for a single day, regardless of the long date time
stamp. The table date formats cannot be altered. I existing prompt requires
the user to enter the exact long date match and not all records have the same
time stamp.
Thanks

The Format of the fields is irrelevant: it just controls how the field is
*displayed*, not what's stored or searched.

You can use a criterion of

= [Enter date:] AND < DateAdd("d", 1, [Enter date:])

to cover the range from midnight at the beginning of the day to
11:59:59.9999999 pm.

John W. Vinson [MVP]