Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Business Central forum / Dynamic Date range in ...
Business Central forum
Suggested answer

Dynamic Date range in field type DateTime

(0) ShareShare
ReportReport
Posted on by RP at CML 5

Hi all,

I am wondering if you could advise on the below query?

 

How do we set a filter in a 'DateTime' type field to only include today, and the previous 6 days (most recent week’s-worth of data)?

In a ‘Date’ type field I would normally use the formula “T-7D..T” to get the required results, but this of course does not work in a 'DateTime' type field.

The exact scenario is setting Change Log Entries as a Job Queue Entry to run weekly, with a week's worth of data being reported. 

Thanks in advance for your help!

Categories:
Reports and Business Intelligence
  • JES @ NLB Profile Picture
    JES @ NLB 5 on at
    RE: Dynamic Date range in field type DateTime

    Just read your post and I use something similar, (dayrange(-7,0)) with the "Matches" setting. It works for both date and date/time so far for me.

    In my case I use 30 days back and 3 days forward:

    pastedimage1682518745191v1.png

  • RP at CML Profile Picture
    RP at CML 5 on at
    RE: Dynamic Date range in field type DateTime

    Yes, in a standard job queue I want to run a report on Change Log Entries that only shows the last 7 days of changes. Change Log only has DateTime fields, no Date fields, so I am unable to use the standard filter I would use in a Date field (T-7D..T). I need to know the syntax for making an equivalent of this formula work in a DateTime field.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,744 Moderator on at
    RE: Dynamic Date range in field type DateTime

    You mean in the standard job queue setup page?

    Or what page and field do you want to use?

  • RP at CML Profile Picture
    RP at CML 5 on at
    RE: Dynamic Date range in field type DateTime

    Hi Inge,

    Thanks for your reply. Is it possible to achieve the results I need purely in the front-end?

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,744 Moderator on at
    RE: Dynamic Date range in field type DateTime

    You can use the createdatetime function to generate the datetime for 6 days prior to today.

    learn.microsoft.com/.../createdatetime-function--datetime-

    First find the date today-6d and then use that date in the createdatetime function.

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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans