How do we convert date stored as string back to date format?

[yasin_fazwani]

"18-JUN-09 11.42.37.000000 AM" is a string. I want to convert into date format

[Akshay1 · Accepted solution]

Hello Yasin,

In order to convert a Text value into a date format - we need to use the Datevalue formula in a computed column. In this case your computed column should look like the one showed below:

datevalue(@Date@ ,"d-MMM-yy hh.mm.ss.SSSSSS a")