Small and medium business | Business Central, N...

Filtering on datetime value

(1) Share

Report

Posted on by Community member

Hi,

I am trying to add a filter in a table using a timedate value. My goal is to get all records from before 3 days earlier than todays date. So in a date value I would use: ..t-3d however when I try to enter this on a datetime value I get an error. Any advice on how to fix this?

I am in a user view only so I cannot change the value or value type in developer view.

Thank you!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (2)

Answers (0)

Ariba Mehdi 164 on at

Like (1)

Report

Hi there,

Check Entering Combined Dates and Times section in the link below.

https://learn.microsoft.com/en-us/dynamics365/business-central/ui-enter-date-ranges

Try these filters:

t-3d 00:00

t-3d 0

t-3d time

Hope it helps!

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,307 Super User 2025 Season 2 on at

Like (0)

Report

Hi, hope the following can give you some hints.

https://community.dynamics.com/forums/thread/details/?threadid=6542cc2c-4220-40fd-8e7d-9ca18ade7ddf

Thanks.

ZHU

Was this reply helpful? Yes No

Join the conversation

Community site session details

Filtering on datetime value

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Filtering on datetime value

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates