Small and medium business | Business Central, N...

Job queue date set up

(2) Share

Report

Posted on by Brett F

454

Hi, how do I set up a job queue to run on:
1) First Monday of the month

2) First day of the month

Thanks!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

YUN ZHU 101,250 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi, Sorry I didn't test it in detail, please try the following first

1) First Monday of the month

2) First day of the month

Thanks

ZHU

Was this reply helpful? Yes No
Suggested answer

Tech-Lucky 1,288 Moderator on at

Like (3)

Report
Copy link

Link copied!
Yes, -CW and -CM are the correct options to achieve your requirements.

CW returns the last day of the current week. By adding a minus sign (-CW), you get the first day of the current week, which is typically Monday.

CM returns the last day of the current month. Using -CM gives you the first day of the current month.

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 16,553 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

Yes I do agree with the experts. You can use "-CW" for first day of the week and "-CM" for first day of the Current Month.

Was this reply helpful? Yes No
Brett F 454 on at

Like (0)

Report
Copy link

Link copied!

It looks like I cannot create a date formula for the first Monday of every month, just the Monday of the current week - right?

It also looks like 1D will give me the first day of the month as well (?)

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,444 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

https://www.encorebusiness.com/blog/12-tips-and-tricks-in-dynamics-365-business-central-video/

Please check this: https://thatnavguy.com/date-formula-in-business-central/

Was this reply helpful? Yes No