topic Re: date fonctions in QlikView https://community.qlik.com/t5/QlikView/date-fonctions/m-p/1293213#M404046 <HTML><HEAD></HEAD><BODY><P>Dear</P><P></P><P>It is a SQL related question better you can discussed this on SQL community.</P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Wed, 23 Nov 2016 08:00:08 GMT its_anandrjs 2016-11-23T08:00:08Z date fonctions https://community.qlik.com/t5/QlikView/date-fonctions/m-p/1293212#M404045 <HTML><HEAD></HEAD><BODY><P>Hello Guys, </P><P></P><P>Hope all is all <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Could anyone explain to me the fonctions to_date/ to_char/to_months ?? and why they are used together in the expression bellow</P><P>date&gt;= to_date(to_char(add_months(SYSDATE,-6),'DD/MM/YYYY'),'DD/MM/YYYY')</P><P></P><P>Thank you so much </P></BODY></HTML> Wed, 23 Nov 2016 07:52:47 GMT https://community.qlik.com/t5/QlikView/date-fonctions/m-p/1293212#M404045 master_student 2016-11-23T07:52:47Z Re: date fonctions https://community.qlik.com/t5/QlikView/date-fonctions/m-p/1293213#M404046 <HTML><HEAD></HEAD><BODY><P>Dear</P><P></P><P>It is a SQL related question better you can discussed this on SQL community.</P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Wed, 23 Nov 2016 08:00:08 GMT https://community.qlik.com/t5/QlikView/date-fonctions/m-p/1293213#M404046 its_anandrjs 2016-11-23T08:00:08Z