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

Job queue date set up

(2) Share

Report

Posted on by Brett F

450

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)

Suggested answer

YUN ZHU 95,763 Super User 2025 Season 2 on at

Like (1)

Report

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,267 Super User 2025 Season 2 on at

Like (3)

Report
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 15,639 Super User 2025 Season 2 on at

Like (1)

Report

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 450 on at

Like (0)

Report

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. 20,971 Super User 2025 Season 2 on at

Like (1)

Report

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