How to show all records for a date using criteria on general date fld? 2

[tgikristi]

I have a report based on query and one of the fields in that query is in the General Data format. I want a way to filter the report or write a criteria for the report's query or something so that if a user enters a date in the MM/DD/YYYY format into an Open Event prompt that I have created, all the records stamped with that date are returned, but since the General date has the time stamp as well, I can't figure out how to write code that will just look at the date portion?

This must be so simple, but I can't figure it out...
Thanks,
tgikristi

 

[LizardKingSchwing]

Theres a load of ways to do this but you may try to utilize the sql between # 1HERE # and # 2HERE # .....

simply get the date value and append 00.00 before date
e.g 00.00 09/16/2002

then 2nd lee append 23.59 before same date for 2nd value
e.g 23.59 09/16/2002

so your statement would be like Select ..... between #00.00 09/16/2002# and #23.59 09/16/2002#

Hopefully , that should work

LK--<

 

[CosmoKramer]

tgikristi,

Try this, changing the prompt to what yours is......

Between ([Enter report date] & " 00:01 ") And ([Enter report date] & " 23:59")

 

[tgikristi]

So simple, so helpful! Thanks very much LizardKingSchwing and CosmoKramer!