Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Need A Dynamic way of setting Date Parameters to begin with the 01st April — Cloud Customer Connect
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

Need A Dynamic way of setting Date Parameters to begin with the 01st April

Received Response
17
Views
3
Comments

Summary:

Hi, I need to schedule an OTBI report that looks at changes made to a salary from the 01st April to the last day of the previous month. For example the report should show changes made from 01/04/2022 to 31/01/2022.

This report needs to be sent out each month so I need the date parameter to dynamically change when we enter a new fiscal year. So when the report is sent out on the 01st May 2023 it needs to show changes made from 01/04/2023 - 31/04/2023 and for June changes from 01/04/2023 - 31/05/2023 etc.

Any help with this would be much appreciated.

Content (required):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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