web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Filtering on datetime ...

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

Suggested Answer

Filtering on datetime value

(1) Share

Report

Report

Posted on by Community member

2

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 Img

All responses (2)

Answers Img

Answers (0)

Ariba Mehdi 166 on at

Like (1)

Report
Copy link

Link copied!

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 99,055 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Helpful resources

Quick Links

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

#1

OussamaSabbouh 1,926 Super User 2026 Season 1

#2

YUN ZHU 1,158 Super User 2026 Season 1

#3

Khushbu Rajvi. 533 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans