Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

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

Summary:

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):

22D

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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