Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
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)

(1) ShareShare
ReportReport
Posted on by vishal.sai.b 44
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
  • Waed Ayyad Profile Picture
    Waed Ayyad 8,550 Super User 2025 Season 1 on at
    how to set the confirmed ship date with lessthandate(30)

    Hi, 

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

    Thanks,

    Waed Ayyad

  • Suggested answer
    Adis Profile Picture
    Adis 4,557 Super User 2025 Season 1 on at
    how to set the confirmed ship date with lessthandate(30)
    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

  • Suggested answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 23,814 Super User 2025 Season 1 on at
    how to set the confirmed ship date with lessthandate(30)
     
    You must use (DayRange(-30,0)) instead of (LessThanDate(30)).
     
    Best regards,
    Mohamed Amine MAHMOUDI
  • Suggested answer
    Adis Profile Picture
    Adis 4,557 Super User 2025 Season 1 on at
    how to set the confirmed ship date with lessthandate(30)
    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

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

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans