Query specific times

[trythis]

I have date/time field
8/24/2009 7:00:00 AM
8/24/2009 11:00:00 AM
8/24/2009 7:30:00 AM
8/24/2009 3:00:00 AM
8/24/2009 5:00:00 AM

8/24/2009 8:00:00 PM
8/24/2009 7:30:00 PM
8/24/2009 11:00:00 PM
8/24/2009 7:00:00 PM
8/24/2009 3:00:00 PM

I found the expression that gives me todays date.

Between Date() And Date()+1

How can I make this give me only the AM times for the current date or 1am to 11am

Thanks,
Tina

 

[boblarson]

Create another field in your query (you don't have to display it) like this:

TV:TimeValue([YourDateTimeFieldName])

And in the criteria use:

>=#1:00:00 AM# And <=#11:00:00 AM#

 

[trythis]

PERFECT!

Can't Thank You enough. I will be sure and give you credit.

thanks,
Tina

 

[boblarson]