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 / 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)
  • Waed Ayyad Profile Picture
    Waed Ayyad 8,947 Super User 2025 Season 2 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 5,652 Super User 2025 Season 2 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 26,311 Super User 2025 Season 2 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 5,652 Super User 2025 Season 2 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

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 > Supply chain | Supply Chain Management, Commerce

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,098

#2
André Arnaud de Calavon Profile Picture

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

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 215 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans