Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
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]
True, but why would Date# fail still?
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.
That makes complete sense ... Thanks
I tried the above format but it's still not responding
Try tresesco's suggestion
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
Please note that the excel file is loaded into the qlik app via SQL