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

I have the same question (0)

All responses (4)

Answers (1)

Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

fatihgork 3,817 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Anna Isaksson 75 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

You don't know how helpful this was... thank you so much.

Was this reply helpful? Yes No