3 Replies Latest reply: Apr 12, 2017 2:43 PM by Sunny Talwar RSS

    How do I concatenate a quarter and year column and convert into date?

    Jes Lee

      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?