Transform an excel date

[QlikTonic]

Hi everybody,

Hope you're well !

My model doesn't recognize the date format, can someone help me to transform '24-jan-19' on 24.01.2019 please ?

dl_qte2	dl_unite	dl_prix	dl_date1	dl_tva_inc	dl_tva_mnt
2		29	24-Jan-19		2.07
1		35	24-Jan-19		1.25
1		18	24-Jan-19		1.29

Thanks in advanced ans nice day !

Chris

[emrekaya · Accepted solution]

date(date#([dl_date1],'DD-MMM-YY'),'DD.MM.YYYY') as date

try this one, and let us know 🙂

[Shubham_Deshmukh]

It will recognoze,
Just try date(dl_date1,'DD.MM.YY').
If it doesn't work, Use format cells in Excel sheet, make date format like 24-Jan-19 and then use date(dl_date1,'DD.MM.YY')

[QlikTonic]

Just perfect many thanks and nice day to all !