Discussion Board for collaboration related to QlikView App Development.
Hi I have one date column year in my excel data
Now i want to cnvert this into date format like Apr-2014
please help me on that.
If your this date field is not a proper date field, you might have to try like:
Date(Date#(YourDateField, 'MMM YYYY'), 'MMM-YYYY') as NewDate
And yes, now I note that your date format is not uniform, somewhere three-letters;somewhere four-letters for month. They are expected to be uniform with three-letters.
Date(Date#(DateFieldName, 'MMM YYYY'), 'MMM-YYYY')
Try like this
=Date(Date#(DateFieldName, 'MMM YYYY'), 'MMM-YYYY')
iam not getting any data as per your expresson
actually the data is not in date format.
first i need to change
above data into date format
is there any way to change above data into date format
Date() and Date#() function to convert the date format, refer my previous post for solution.