web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Filtering on datetime ...
Small and medium business | Business Central, N...
Suggested answer

Filtering on datetime value

(1) ShareShare
ReportReport
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)
  • Ariba Mehdi Profile Picture
    Ariba Mehdi 164 on at
    Filtering on datetime value
    Hi there,

    Check Entering Combined Dates and Times section in the link below.
     
     
    Try these filters:

    t-3d 00:00
    t-3d 0
    t-3d time

    Hope it helps!
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 92,507 Super User 2025 Season 2 on at
    Filtering on datetime value
    Hi, hope the following can give you some hints.
     
     
    Thanks.
    ZHU

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,202

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 3,248

#3
Sumit Singh Profile Picture

Sumit Singh 2,893

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans