Oracle Analytics

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to use current date in a parameter

Received Response
41
Views
3
Comments
User_3YQO6
User_3YQO6 Rank 2 - Community Beginner

Hello,

I am building some workbooks using OAC and OAS. I understand I can use system parameters as current date but how can I create a user defined parameter that is current date-3 (3 days ago) for example. I know I can easily create a calc to return current date and or current date -3 but instead of using calc as the filter I wanted to pass the parameter in my filter control and default the dates to what I wanted. For current date it's not a problem but I don't know how to do the same for current date 3 days ago.

ultimately, I want to be able to bind those parameters to my data set columns so the initial value gets populated correctly.

Thanks

Syed

Answers