Adding days to the Date prompt in OTBI

Summary

Adding days to the Date prompt in OTBI

Content

Hi Team,

I have one requirement to add 6 days to the prompt date and fetch the value based on the new value. +6 or date_add, TIMESTAMPADD is not working.

Below is the column value I have used. I have to add 6 days to both of the prompts (FYTD/CURR_DT)

CASE "Payroll - Payroll Balances Real Time"."Balance Types"."Balance Name"   WHEN 'Deferred Compensation 401K Eligible Earnings' THEN  FILTER("Payroll - Payroll Balances Real Time"."Balance Value"."Balance Value" USING ("Payroll - Payroll Balances Real Time"."Payroll Period"."End Date" between date '@{FYTD}{2019-10-28}' AND date '@{CURR_DT}{2020-10-20}'))