How to pass default value in filter for between clause

Question

Hello,

I am using a filter on "Effective Date" column which is taking start/end date from dashboard prompt with presentation variable.

Now issue is, i want to have some dynamic default values for both start/end date.

Below is the filter which i am using -

For Default values, it doesn't pick the TIMESTAMPADD function.

So as a Default values, End date should be MAX("Master Mappings"."Effective Date") and Start Date should be (MAX("Master Mappings"."Effective Date") -6) means 6 month earlier one.

Please help to achieve the same.

Thanks

Chandra M.

Robert Angel · Answer

Why not default on your prompts?

Otherwise, you are currently casting as a date and then treating it as a timestamp, you need to explicitly convert it to a timestamp.

Not convinced your max requirement is achievable in a default, unless any knows otherwise?