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

    Month & Year

    UPALI WIJERATNE

      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],