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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / how to set the confirm...
Supply chain | Supply Chain Management, Commerce
Suggested Answer

how to set the confirmed ship date with lessthandate(30)

(2) ShareShare
ReportReport
Posted on by vishal.sai.b 58
Hello Experts,
i looking for the right to set the filters for confirmed ship date as below
we have set the filter for the confirmed ship date as (LessThanDate(30)), but for confirmed ship date the record more 30 day are being populated after the applying the filter,

please let me did i set the filter correctly??

Thanks in Advance



screenshot of advance filters and sort

Categories:
Dynamics 365 Supply Chain Management
I have the same question (0)
  • Suggested answer
    Adis Profile Picture
    Adis 6,069 Super User 2025 Season 2 on at
    Hi,
     
    Try this (LessThanDate(-30)).
     
     

    Kind regards, Adis

     

    If this helped, please mark it as "Verified" for others facing the same issue

    Keep in mind that it is possible to mark more than one answer as verified

  • Suggested answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 26,445 Super User 2025 Season 2 on at
     
    You must use (DayRange(-30,0)) instead of (LessThanDate(30)).
     
    Best regards,
    Mohamed Amine MAHMOUDI
  • Suggested answer
    Adis Profile Picture
    Adis 6,069 Super User 2025 Season 2 on at
    Hi,
     
    Maybe I misunderstood. Depending what you want, you need to use DayRange or LessThanDate.
     
    Lets say today is the 30th of May.
     
    (DayRange(-30,0)) : It will give you all records between 1st and 30th of May
    (LessThanDate(-30)) : It will give you all records before 1st of May.
     
     
     

    Kind regards, Adis

     

    If this helped, please mark it as "Verified" for others facing the same issue

    Keep in mind that it is possible to mark more than one answer as verified

  • Waed Ayyad Profile Picture
    Waed Ayyad 9,039 Super User 2025 Season 2 on at

    Hi, 

    Is your issue resolved? If yes, mark the answers that helped you as verified. 

    Thanks,

    Waed Ayyad

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 303 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 122 Super User 2025 Season 2

#3
Siv Sagar Profile Picture

Siv Sagar 105 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Quality order uses default receipt location instead of actual physical receipt location

Product updates

Dynamics 365 release plans