Criteria for "Today" when Date/Time

[Chillendw]

So I'm trying to create a query to show me today's transactions.
I thought it would be as easy as =Date()
Alas, I'm here...

So I'm thinking it's because I have date and time in the field. And it's captured by Now() in some forms.

How can I go about getting today's records.

Thanks in advance.

 

[isladogs]

In the UK you would use

=Format(transactiondate,"dd/mm/yyyy")

Where transactiondate is your field name

If in the USA its mm/dd/yyyy

 

[almahmood]

Use Int([YourDateField])=Date(). Int will help you to convert a datetime to date.

 

[isladogs]

Hi almahmood

I can see that would work, but I think its harder for users to understand

 

[Chillendw]

Use Int([YourDateField])=Date(). Int will help you to convert a datetime to date.

Thanks almahmood!
This worked for me.