Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
varunreddy
Creator III
Creator III

Converting Timestamp to Date format

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

   

1 Solution

Accepted Solutions
neelamsaroha157
Specialist II
Specialist II

Try this -

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

View solution in original post

2 Replies
neelamsaroha157
Specialist II
Specialist II

Try this -

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

varunreddy
Creator III
Creator III
Author

Thanks Neelam for the quick response

Cheers,

Varun