Date convertion - Apr 10 2018 12:00AM to 10/04/201... - Qlik Community

Report Inappropriate Content · ‎2017-10-11

Hi

I am trying to convert this date format 'Apr 10 2018 12:00AM' to '10/04/2018' in Qlik Sense. Please let me know if you come across to the solution to this?

Thanks

kaushiknsolanki · ‎2017-10-11

Try this expression

Date(Floor(Timestamp#('Apr 10 2018 12:00AM','MMM DD YYYY hh:mmTT')),'DD/MM/YYYY')

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Date convertion - Apr 10 2018 12:00AM to 10/04/2018