I have the date in the format "01AUG2017:09:24:17.000000". Not sure how to convert into "DD-MMM-YY".
Can any one please help me with this?
Attached the sample data and QVW file.
Thanks in advance!
Try this -
Date(Date#(Left(Date,9), 'DDMMMYYYY'), 'DD/MM/YYYY')
View solution in original post
Thanks Neelam for the quick response