1 Reply Latest reply on Aug 30, 2013 11:02 AM by Alex Kerin

    How to I convert columns into a date field?  My data comes over as [MONTH] and [YEAR]

    Stephanie  Manley

      I want to convert these two columns into a calculated field.  I have tried this, and obviously it doesn't work

       

      Calculated field Name: Extended date

       

      ([MONTH})+"/1/"+[YEAR])

       

      I want this

      01/01/2010

       

       

      Thanks!

      Stephanie