Need help

Summary

Need help with the Date prompt in OTBI report

Content

I have set up a  date presentation variable for a OTBI report as a prompt (P_TO). Now I want to use the same in the SQL expression used in the filter set for one of field in the report (some thing like this) so that the report pulls all data between prompt date and prompt date -6. Can somebody help me with the expression.

"Element Entry"."Element Entry Creation Date" BETWEEN timestampadd(SQL_TSI_DAY,-6,DATE'@{P_TO}') AND @{P_TO}{date '2019-11-28'}