Transform 'M/D/YYYY' string as DD/MM/YYYY date

[jpaviles1]

Hello Qlik Community,

On the attached Excel file, it seems dates are reported as M/D/YYYY string - Capture1.

When trying Date#("Timestamp",'DD/MM/YYYY') as "Timestamp1" on the Data Load Editor, I get result as per Capture2.

How to get date range properly reported from 09/12/2023 to 08/01/2024?

Thank you,

Jose

[Parthiban]

Hi,

Try this one

Date(date#(Timestamp,'M/D/YYYY'),'DD/MM/YYYY') as Timestamp1

[jpaviles1 · Accepted solution]

Hello @Parthiban ,

It works! 🙂

On the Line Chart I have, I disabled Continues scale

And this is the result:

Thanks a million, it is really appreciated 🙂

Kind regards,

Jose