Converting Timestamp to Date format

[varunreddy]

Hi All,

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!

Cheers,

Varun

[neelamsaroha157 · Accepted solution]

Try this -

Date(Date#(Left(Date,9), 'DDMMMYYYY'), 'DD/MM/YYYY')

[varunreddy]

Thanks Neelam for the quick response

Cheers,

Varun