Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

QlikTonic
New Contributor II

Transform an excel date

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_qte2dl_unitedl_prixdl_date1dl_tva_incdl_tva_mnt
2 2924-Jan-19 2.07
1 3524-Jan-19 1.25
1 1824-Jan-19 1.29
      
      

Thanks in advanced ans nice day !

Chris

1 Solution

Accepted Solutions
emrekaya
New Contributor III

Re: Transform an excel date

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

 

try this one, and let us know 🙂

3 Replies
emrekaya
New Contributor III

Re: Transform an excel date

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

 

try this one, and let us know 🙂

Shubham_Deshmukh
Valued Contributor

Re: Transform an excel date

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
New Contributor II

Re: Transform an excel date

Just perfect many thanks and nice day to all !