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:

Business Central

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 73,647 Super User 2024 Season 2 on at

Like (0)

Report

Filtering on datetime value

Hi, hope the following can give you some hints.

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

Thanks.

ZHU
Ariba Mehdi 160 on at

Like (1)

Report

Filtering on datetime value

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!

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans