4 Replies Latest reply: Oct 20, 2014 12:50 AM by UPALI WIJERATNE RSS

    Month & Year


      I have following data field in a data table


      Month    Year

      Jan        2012

      Jan        2012

      Feb        2013

      Mar         2014


      and I want to convert it to date field as TRN_DATE. I have written following script which is not working. Kindly let me know where I am wrong


         Date(MonthEnd(Date#([Year] &'-'& [Month],'YYYY-MM')),'DD-MMM-YYYY')     AS [TRN_DATE],