News and Announcements icon

Dynamics 365 CommunityForums Business Central forum Date Formula

Business Central forum

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:

Reports and Business Intelligence

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Mohana Yadav 58,864 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

Community member 21 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... 290,326 Super User 2024 Season 2

#2

Martin Dráb 228,166 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans