2 Replies Latest reply: May 22, 2015 12:45 AM by chinna katiki RSS

    Qlikview Wierd Behaviour for Date conversion

    chinna katiki

      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