Load yyyy-mm-dd as mm/dd/yyyy

[#1]

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

[Digvijay_Singh]

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

[#3]

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

[Digvijay_Singh]

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

[Digvijay_Singh]

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

[sunny_talwar]

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

[maniram23]

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]

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

[sasiparupudi1]

May be try

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

hth

Sasi

[#10]

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

Thanks