topic Compare Date Formats in QlikView https://community.qlik.com/t5/QlikView/Compare-Date-Formats/m-p/969153#M971222 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I extracted datas from my oracle database. These datas are in date format, so they look very similar to timestamp format. </P><P>So how I can compare them in QlikView? I only want to count the datas which are smaller than system time. My try looks like this:</P><P></P><P>=count({$&lt;[HK_NAME_KURZ]={'BUDSTART'},[ANZAHL]={"&gt;=1"},[BAUP_DATUM_GUELTIG_BIS]={"&gt;$(=Timestamp(Now(2)))"}&gt;} [KUNDE_BPR_ID]) </P><P></P><P>Regards, Moe.</P></BODY></HTML> Thu, 17 Sep 2015 08:51:05 GMT 2015-09-17T08:51:05Z Compare Date Formats https://community.qlik.com/t5/QlikView/Compare-Date-Formats/m-p/969153#M971222 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I extracted datas from my oracle database. These datas are in date format, so they look very similar to timestamp format. </P><P>So how I can compare them in QlikView? I only want to count the datas which are smaller than system time. My try looks like this:</P><P></P><P>=count({$&lt;[HK_NAME_KURZ]={'BUDSTART'},[ANZAHL]={"&gt;=1"},[BAUP_DATUM_GUELTIG_BIS]={"&gt;$(=Timestamp(Now(2)))"}&gt;} [KUNDE_BPR_ID]) </P><P></P><P>Regards, Moe.</P></BODY></HTML> Thu, 17 Sep 2015 08:51:05 GMT https://community.qlik.com/t5/QlikView/Compare-Date-Formats/m-p/969153#M971222 2015-09-17T08:51:05Z Re: Compare Date Formats https://community.qlik.com/t5/QlikView/Compare-Date-Formats/m-p/969154#M971223 <HTML><HEAD></HEAD><BODY><P>Oh, it was my fault. Syntax worked with only Now(). </P></BODY></HTML> Thu, 17 Sep 2015 09:48:49 GMT https://community.qlik.com/t5/QlikView/Compare-Date-Formats/m-p/969154#M971223 2015-09-17T09:48:49Z