I am using a SQL Component to generate a view. I am pivoting in the SQL component and currently have my pivot values as dates that are hard coded. I want to replace those dates with variables ${last_day_q1_current_year}.
I have tried swapping out 2023-03-31 for ${last_day_q1_current_year} which throws a mismatched data type error and I have tried adding single quotes '${last_day_q1_current_year}' which validates but creates a field '2023-03-31' with no values.
I have tried putting date in front of '${last_day_q1_current_year}' but am not having any luck.