topic Re: Transform 'M/D/YYYY' string as DD/MM/YYYY date in App Development

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

jpaviles1 — Wed, 10 Jan 2024 11:22:12 GMT

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 — Wed, 10 Jan 2024 11:43:20 GMT

Hi,

Try this one

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

jpaviles1 — Wed, 10 Jan 2024 12:01:11 GMT

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