1 Reply Latest reply on Dec 30, 2016 5:42 AM by Norbert Maijoor

    Only months column (In numbers 1-12)  given how do I convert to date format ?

    ch deepak

      I used reference date  as DATE("1"+"/"+ STR([Month])+"/"+"2016")

      And DATEADD function DATEADD('month',[Month]-1,[reference date ])

       

      But it isn't working, it's going to default year dec 1899.