Solved: Load yyyy-mm-dd as mm/dd/yyyy - Qlik Community

Report Inappropriate Content · ‎2015-09-21

Hi how would I load my dates as above ?

I have tried Date(date#(Date,'YYYY-MM-DD'), 'MM/DD/YYYY') but to no avail

Report Inappropriate Content · ‎2015-09-22

Thanks for your help ... School boy error on my part as I had the input date as yyyy-mm-dd rather than yyyy-dd-mm

Digvijay_Singh · ‎2015-09-21

This looks fine, Can you share sample data and complete statement to verify further. Could be extra space here and there.

Report Inappropriate Content · ‎2015-09-21

Date(date#(Date,'YYYY-MM-DD'),'MM/DD/YYYY') as SALES_DATE

Digvijay_Singh · ‎2015-09-21

Any sample data if you can share? Will apply and see why it is not working.

Digvijay_Singh · ‎2015-09-21

I applied this in text box - =Date(date#('2015-09-21','YYYY-MM-DD'),'MM/DD/YYYY'), you can see it worked.

sunny_talwar · ‎2015-09-21

I agree with Digvijay, I don't see any problem with what you have. A sample would be helpful here.

maniram23 · ‎2015-09-21

Hi,

Please Check the date format.

if you give date like 10-12-2014 than you give format also "DD-MM-YYYY".

see this one =Date(date#('2014-02-01','YYYY-MM-DD'), 'MM/DD/YYYY')

qlikview979 · ‎2015-09-21

YES . I agree with Digvijay singh and mani ram .its correct

sasiparupudi1 · ‎2015-09-21

May be try

Date(Date#(trim(Date),'YYYY-MM-DD'), 'MM/DD/YYYY')

hth

Sasi

Report Inappropriate Content · ‎2015-09-21

Thank you all for the responses however none of the solutions work. I am attaching my sample data.

Thanks