Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikTonic
Contributor III
Contributor III

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
Contributor III
Contributor III

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

 

try this one, and let us know 🙂

View solution in original post

3 Replies
emrekaya
Contributor III
Contributor III

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

 

try this one, and let us know 🙂

Shubham_Deshmukh
Specialist
Specialist

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
Contributor III
Contributor III
Author

Just perfect many thanks and nice day to all !