Date Format

[akpofureenughwu]

I have a date field whose format is MM/DD/YYYY.

My prefered format is DD/MM/YYYY

How do I convert it to the prefered format

Regards

_________________________________________

[Inflow]:

LOAD

     [Date]as [Inflow_Date],

    [ASSET] as [Inflow_Asset],

    [CATEGORY] as [Inflow_Category],

    [YEAR]  as [Inflow_Year],

    [AMOUNT_k] as [Inflow_AMOUNT_k],

    [AMOUNT_j] as [Inflow_Amount_j]

FROM [lib://WIN-WIN/xxxxx.xlsx]

(ooxml, embedded labels, table is Inflow);

[tresB]

It is already being read as proper date, so only date() should be enough to change the format. Try like:

Date( [Date], 'DD/MM/YYYY') AS [Inflow_Date] 

[sunny_talwar]

True, but why would Date# fail still?

[tresB]

Screen shot he is sharing probably from a listbox where the number format could have been set differently. For example, the original field might be having other timestamps like hhmmss..for which date#() might be failing.

[sunny_talwar]

That makes complete sense ... Thanks

[akpofureenughwu]

I tried the above format but it's still not responding

[sunny_talwar]

Try tresesco‌'s suggestion

[akpofureenughwu]

Hello Treseco

Thanks for stopping by...

The sample file I used for this design is attached to this feed.

The date field is in this format:  MM/DD/YYYY

[akpofureenughwu]

Please note that the excel file is loaded into the qlik app via SQL