Filter by today's date

(0) Share

Report

Posted on by Anna Isaksson

Hi,

I need to filter for records in a customized table based on today's date. The field available is a Date Time field and it doesn't work to filter with "d" or "t". Any ideas on how to filter?

Thanks

Anna

Categories:

Other

All responses (4)

Answers (1)

Community Member on at

Like (1)

Report

RE: Filter by today's date

You don't know how helpful this was... thank you so much.
Anna Isaksson 75 on at

Like (1)

Report

RE: Filter by today's date

The filter was in a list view. The response below helped. (Day(0)) worked fine.
Verified answer

fatihgork 3,815 on at

Like (1)

Report

RE: Filter by today's date

Can you use advanced filtering?

(Day(0)) works for today in advanced filtering.

For other syntaxes you can check this link: Advanced filtering and query syntax
Martin Dráb 231,768 Most Valuable Professional on at

Like (0)

Report

RE: Filter by today's date

Where do you want to set the filter? In a form? In batch criteria? In X++ code? In an AOT query? Or somewhere else?