topic Need help in sql where condition in QlikView https://community.qlik.com/t5/QlikView/Need-help-in-sql-where-condition/m-p/734272#M1069642 <HTML><HEAD></HEAD><BODY><P>Hi Guru's,</P><P></P><P>As I need a 'YYYYMM' format of date in the SQL WHERE condition.</P><P></P><P>like in our Load statement we can write </P><P></P><P>Date(MonthName(PurchaseDate),'YYYYMM') as PurchaseDate but I want the same expression in sql Where condition.</P><P></P><P>How do i write that</P></BODY></HTML> Mon, 25 Aug 2014 09:45:17 GMT 2014-08-25T09:45:17Z Need help in sql where condition https://community.qlik.com/t5/QlikView/Need-help-in-sql-where-condition/m-p/734272#M1069642 <HTML><HEAD></HEAD><BODY><P>Hi Guru's,</P><P></P><P>As I need a 'YYYYMM' format of date in the SQL WHERE condition.</P><P></P><P>like in our Load statement we can write </P><P></P><P>Date(MonthName(PurchaseDate),'YYYYMM') as PurchaseDate but I want the same expression in sql Where condition.</P><P></P><P>How do i write that</P></BODY></HTML> Mon, 25 Aug 2014 09:45:17 GMT https://community.qlik.com/t5/QlikView/Need-help-in-sql-where-condition/m-p/734272#M1069642 2014-08-25T09:45:17Z Re: Need help in sql where condition https://community.qlik.com/t5/QlikView/Need-help-in-sql-where-condition/m-p/734273#M1069643 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>If you need SQL function for it</P><P>then use</P><P>to_char(trunc(sysdate),'yyyymm')</P><P></P><P>Regards</P></BODY></HTML> Mon, 25 Aug 2014 09:53:41 GMT https://community.qlik.com/t5/QlikView/Need-help-in-sql-where-condition/m-p/734273#M1069643 PrashantSangle 2014-08-25T09:53:41Z