Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

chinnakatikisg
Valued Contributor

Qlikview Wierd Behaviour for Date conversion

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:MMSmiley FrustratedS') 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:MMSmiley FrustratedS')) 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:MMSmiley FrustratedS'),'DD/MM/YYYY') also giving as 22/10/2015.

BR,

Chinna

Tags (1)
1 Solution

Accepted Solutions
greeshma_k
Contributor III

Re: Qlikview Wierd Date behaviour

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

2 Replies
greeshma_k
Contributor III

Re: Qlikview Wierd Date behaviour

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

chinnakatikisg
Valued Contributor

Re: Qlikview Wierd Behaviour for Date conversion

Yeah, I understand that MM is considering as Month number instead of minutes..