You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

What is the formual to use when scheduling a report to pull data from the previous month

Received Response
edited Dec 7, 2022 1:06AM in Reporting and Analytics for SCM 1 comment


I am attempting to run a scheduled report. The report would run on the first of the month for the previous months cycle count program results. In past releases, I have been able to use, $SYSDATE()-31$. Currently in 22D I receive an error message when an attempt is made to use this.

Content (required):

Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!