News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Date Formula

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

Answered

Date Formula

(1) Share

Report

Report

Posted on by Wspares

12

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

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Mohana Yadav 60,050 Super User 2024 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
Suggested answer

SL-02010912-0 62 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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2

Martin Dráb 230,371 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans