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

    How to convert a string date to Date type?


      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?