How can you filter a [data + time] field by just date? (1 Viewer)

S

stell

Registered User.

Local time

Today, 02:27

Joined

Jun 14, 2017

Messages

15

• Sep 13, 2018

• #1

So basically, I set up a macro using the now() function on a form. Now I want to write a query that filters those records by date. I can't quite figure it out because the field has both data AND time and when I set the criteria to =date() it gives me no results.

Any advice would be appreciated!

 

P

plog

Banishment Pending

Local time

Today, 04:27

Joined

May 11, 2011

Messages

11,638

• Sep 13, 2018

• #2

Wrap your date/time field in DateValue()


DateValue([DateTimeFieldName])

 

S

stell

Registered User.

Local time

Today, 02:27

Joined

Jun 14, 2017

Messages

15

• Sep 13, 2018

• #3

Perfect! Thank you

 

G

Galaxiom

Super Moderator

Staff member

Local time

Today, 19:27

Joined

Jan 20, 2009

Messages

12,851

• Sep 13, 2018

• #4

This will perform vastly better than applying a function to every value in the table:

Code:Copy to clipboard

WHERE [DateTimeField] >=Date() AND [DateTimeField] < Date() + 1