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

[sasiparupudi1]

try

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

[sasiparupudi1]

your date format is YYYY-DD-MM which is odd

[MarcoWedel]

Hi,

one solution could be:

LOAD Region,
    Country,
    [Company Code],
    Date(Date#(Date,'YYYY-DD-MM'),'MM/DD/YYYY') as Date
FROM [https://community.qlik.com/servlet/JiveServlet/download/871115-186085/test.xlsx] (ooxml, embedded labels, table is Sheet1);

or simply

LOAD Region, 
     Country, 
     [Company Code], 
     Date(Date#(Date,'YYYY-DD-MM')) as Date
FROM [https://community.qlik.com/servlet/JiveServlet/download/871115-186085/test.xlsx] (ooxml, embedded labels, table is Sheet1);

if your DateFormat variable already holds the required format.

hope this helps

regards

Marco

[Digvijay_Singh]

If possible can you correct the Title of this issue, as the source date format is not rightly mentioned which you have in your data, try like this -

=Date(date#('2015-21-09','YYYY-DD-MM'),'MM/DD/YYYY')

[SreeniJD]

Pretty Simple... try this for your sample data.. it will display correct results!

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

Happy to help!

[avinashelite]

Please find the attachment for the solution

[#8]

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

[#9 · Accepted solution]

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

[sasiparupudi1]

Please close this thread marking your resolution as the correct answer