topic help with giving condition on datetime field in QlikView https://community.qlik.com/t5/QlikView/help-with-giving-condition-on-datetime-field/m-p/180404#M46857 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>Use the to_Char function like below</P><P></P><P>to_char(Date, 'DD-MM-YYYY') &gt;= Date(systemdate,'DD-MM-YYYY')</P><P></P><P></P><P></P></BODY></HTML> Mon, 24 Jan 2011 04:43:52 GMT deepakk 2011-01-24T04:43:52Z help with giving condition on datetime field https://community.qlik.com/t5/QlikView/help-with-giving-condition-on-datetime-field/m-p/180403#M46856 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have a query which works fine in oracle toad when i give a condition like</P><P>Where table1.datetimefield between '01-dec-2010' and '31-dec-2010'</P><P>but when i copy and paste same sql in qlikview it does not fetch any data ,</P><P>do i need follow any format when giving a between condition in qlikview?</P><P>Please Help</P><P>Thanks...</P><P></P></BODY></HTML> Sun, 23 Jan 2011 21:18:43 GMT https://community.qlik.com/t5/QlikView/help-with-giving-condition-on-datetime-field/m-p/180403#M46856 Anonymous 2011-01-23T21:18:43Z help with giving condition on datetime field https://community.qlik.com/t5/QlikView/help-with-giving-condition-on-datetime-field/m-p/180404#M46857 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>Use the to_Char function like below</P><P></P><P>to_char(Date, 'DD-MM-YYYY') &gt;= Date(systemdate,'DD-MM-YYYY')</P><P></P><P></P><P></P></BODY></HTML> Mon, 24 Jan 2011 04:43:52 GMT https://community.qlik.com/t5/QlikView/help-with-giving-condition-on-datetime-field/m-p/180404#M46857 deepakk 2011-01-24T04:43:52Z