topic Re: Transform an excel date in App Development

Transform an excel date

QlikTonic — Mon, 08 Apr 2019 09:37:52 GMT

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

Re: Transform an excel date

emrekaya — Mon, 08 Apr 2019 10:05:12 GMT

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

try this one, and let us know 🙂

Re: Transform an excel date

Shubham_Deshmukh — Mon, 08 Apr 2019 10:07:56 GMT

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')

Re: Transform an excel date

QlikTonic — Mon, 08 Apr 2019 10:15:56 GMT

Just perfect many thanks and nice day to all !