Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
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:MM:SS') 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:MM:SS')) 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:MM:SS'),'DD/MM/YYYY') also giving as 22/10/2015.
BR,
Chinna
Hi,
Try this
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.
Regards,
Greeshma
Hi,
Try this
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.
Regards,
Greeshma
Yeah, I understand that MM is considering as Month number instead of minutes..