Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date conversion

Hi,

How to convert this text values of date into correct date values like 1-Aug-12 and

1-Aug-12 this to be conerted into

01-08-2012

Thanks

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

date(date#('1-Aug-12','D-MMM-YY'), 'DD-MM-YYYY')

View solution in original post

2 Replies
Anonymous
Not applicable
Author

date(date#('1-Aug-12','D-MMM-YY'), 'DD-MM-YYYY')

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

Assuming that '1-Aug-12' is a text field in your data source, then this should do it (just change the fieldname InputDate to the correct field name containing the 1-Aug-12 date string):

Date(Date#(InputDate, 'D-MMM-YY'), 'DD-MM-YYYY')

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein