9 Replies Latest reply: Feb 19, 2015 12:49 AM by gokulnath arumugam RSS

    String date to num date

    gokulnath arumugam

      Hi all,

       

      In my data, date is in string format.I want to converted it in to number format.

      I used below query for the conversion.

      date(date#([AssignEndDt  ],'MM/DD/YYYY'),'MM/DD/YYYY') as end_date

      but it was not working.