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.