Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date format change in qlik?

Hi community,

     I have date column in my csv file in two formats,

1.format = mm/dd/yyyy

2.number format= 41730,

monthname(Date(alt("Inv Date", Date(Date#("Inv Date", 'MM/DD/YYYY'), 'MMM-YYYY'),

Date(num("Inv Date"), 'MMM-YYYY') ))) as "Invoice Date" ,

used above script to change the format,

when i am trying to change the format to mmm-yyyy, system is getting confused to take some records

for example : 10/01/2015(oct 1st 2015) but it is loading as Jan 2015(Jan 10th 2015).

And am not sure how the number format is changing.

Please help me how can I resolve this.

10 Replies

This should work for you:

Date(Date#([Inv date], 'MM/DD/YYYY'), 'MMM-YYYY') as [Expected Output]

View solution in original post