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 / Ignore weekends in Dat...
Supply chain | Supply Chain Management, Commerce
Suggested answer

Ignore weekends in Date Filters ifor a batch job

(0) ShareShare
ReportReport
Posted on by Charles0252 84

Hi 

Is there anyway in a batch job to exclude weekends in the query.

Currently we release Sales orders to the warehouse where requested ship is within 2days of today

where requested shipdate = (LessThanDate(2)) 

The problem with this is it counts weekend days as well, we need to this to work on working days only 

Thanks

I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 298,941 Super User 2025 Season 2 on at
    RE: Ignore weekends in Date Filters ifor a batch job

    Hi Charles0252,

    There is no easy setup for this. A workaround would be setting up the batch 5 times to run weekly and per batch job pick one of the workdays. The visibility in the Batch job forms can be managed to include the workday in the description.

  • Charles0252 Profile Picture
    Charles0252 84 on at
    RE: Ignore weekends in Date Filters ifor a batch job

    Hi

    Thanks for the reply but I don't think that will work, as this will only dictate the day that the batch runs, so my Job that runs on Friday still does not release the Monday work as its 3 days out.

    Increasing the number of days ahead also cause problems as we then release to many orders to early

  • Suggested answer
    saurabh bharti Profile Picture
    saurabh bharti 15,039 Moderator on at
    RE: Ignore weekends in Date Filters ifor a batch job

    Can't we use this under recurrence? and exclude days when we don't want ?

    pastedimage1625107869526v1.png

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,020

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294 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