Discussion board where members can get started with Qlik Sense.
To day I'm facing some strange issue while removing time stamp using date function. This is happening for my date column as well as static date.
Help me to identify the reason behind this behaviour.
ex: Date#('22/05/2015 10:10:04','DD/MM/YYYY HH:MMS') is giving result as 22/05/2015 10:10:04
If I try to remove time by modifing above as follows :
date(Date#('22/05/2015 10:10:04','DD/MM/YYYY HH:MMS')) is giving result as 22/10/2015
Instead of 05 I'm getting 10 for month
Also I tried like this:
date(Date#('22/05/2015 10:10:04','DD/MM/YYYY HH:MMS'),'DD/MM/YYYY') also giving as 22/10/2015.
Go to Solution.
date(Date#('22/5/2015 10:10:04','DD/MM/YYYY h:mm:ss'),'DD/MM/YYYY')
The time part should be in small case.
Yeah, I understand that MM is considering as Month number instead of minutes..