This content has been marked as final. Show 3 replies
I'm trying to concatenate a row containing the quarter (Q1, Q2, Q3, Q4) and year (1990,1991,...) and turn it into a date. I tried using the following code:
Date(Makedate("Year"), 'YYYY') as YEAR,
Date(Makedate("Year",right(Qrt,2)), 'QQYYYY') as QuarterYEAR,
It's not working as intended. What am I doing wrong?