Criteria - Date

[Amy35]

Hello all -
It's been a while. I need to update my database, and now I'm rusty since it's been over a year.

I need to alter my query for "todays tickets" . When a user submits a ticket, I have a field "Ticket Date" that now also includes the time. So it's a date time field. My query no longer works b/c in the criteria I have =Date()
How do I get it to only grab the date from that "Ticket Date" field? DO i need to separate it into 2 fields one for date and one for time? Or is there another way to set the criteria?
Thanks for the help!

Amy

 

[Jon K]

Use this setting in a column in the query grid:-

Field: DateValue([Ticket Date])

Crtieria: Date()


Note. The DateValue() function returns the date, ignoring the time.

 

[Amy35]

Thanks Jon!

I knew it had something to do with the datevalue just couldn't figure out the syntax. I appreciate the help!