13 Replies Latest reply on Feb 19, 2013 4:31 PM by Cristian Vasile

    How to convert a string date to Date type?

    pankaj.tamrakar

      How can I convert a string type (containing date) into a date type. Right now I'm using below formula and conveting it to a date using Date built-in function.

       

      Date(MID(str([Recog Start Date - YYYYMMDD]),5,2)+"/"+MID(str([Recog Start Date - YYYYMMDD]),7,2)+"/"+MID(str([Recog Start Date - YYYYMMDD]),1,4))

       

      But when I use this field, it doesn't come a date format but comes as count, which I don't want.

       

      Any idea?