Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Filter Dates to Only See Yesterday's Values

Posted on by 10

I am trying to create a report that pulls information from the previous day.  How do I create this filter?  I know T=today.  I was hoping T-1 would equal yesterday but it does not.  

Categories:
  • Aaron Butler23 Profile Picture
    Aaron Butler23 10 on at
    RE: Filter Dates to Only See Yesterday's Values

    This worked.  Thank you so much

  • vinitgoyal2005 Profile Picture
    vinitgoyal2005 6,326 on at
    RE: Filter Dates to Only See Yesterday's Values

    Hi,

    How are you setting the values for filter?

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 225,588 Super User on at
    RE: Filter Dates to Only See Yesterday's Values

    You can use (day(-1)) as a query range.

    It's coming from SysQueryRangeUtil class, where you can see other useful methods and event add your own (if you can access code, of course).

    Some documentation can be found under Advanced filtering and query syntax.

  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,417 on at
    RE: Filter Dates to Only See Yesterday's Values

    Hi Aaron you can use a value of today() - 1.

    Were are you trying to set this filter?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,986 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans