Skip to main content

Notifications

Announcements

No record found.

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

Date Formula

(1) ShareShare
ReportReport
Posted on by 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.
 
  
  • Verified answer
    Mohana Yadav Profile Picture
    Mohana Yadav 60,050 Super User 2024 Season 2 on at
    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 Profile Picture
    SL-02010912-0 62 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans