Date Formula

(1) Share

Report

Posted on by Wspares

Good day,

I am trying to create a Job Queue scheduled report to send me the sales for a specific group of customers for the month thus far. Below is the snapshot of how I have configured the report request page:

However, whilst the report is running successfully every day, it is giving me zero values for the sales as below:

I suspect it is my date formula? I am putting /CM/ in the Filter Totals by > Date Filter/ section? Is that correct? If not, what would the correct date formula be so that I get sales month to date for these customers?

Thank you in advance for any assistance.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Mohana Yadav 60,604 Super User 2025 Season 2 on at

Like (1)

Report

Date Formula

Please try

-CM..CM

-CM will return first date of month

CM will return last date of month

Was this reply helpful? Yes No
Suggested answer

SL-02010912-0 67 on at

Like (1)

Report

Date Formula

Hi,

If you use 'p' instead as below.

Then it should set the dates to the period as shown below.

That should work as expected.

Hope that helps,

Shauna

Was this reply helpful? Yes No