cancel
Showing results for 
Search instead for 
Did you mean: 

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

Highlighted
Blue LED
"18-JUN-09 11.42.37.000000 AM" is a string. I want to convert into date format
Labels (1)
0 Kudos
1 Reply
Highlighted
DC Motor
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")




0 Kudos