topic Re: How to get a date difference from today in QlikView https://community.qlik.com/t5/QlikView/How-to-get-a-date-difference-from-today/m-p/527553#M197143 <HTML><HEAD></HEAD><BODY><P>Simon, </P><P></P><P>you probably need to interpret your Createdate as date, so QV assings a numeric value representation to the value, thus allowing Now() - Createdate to return the number of days.</P><P></P><P>Please check</P><P><A _jive_internal="true" class="loading active_link" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/02/19/why-don-t-my-dates-work" title="http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/19/why-don-t-my-dates-work">http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/19/why-don-t-my-dates-work</A></P><P><A _jive_internal="true" class="loading" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/07/07/automatic-number-interpretation" title="http://community.qlik.com/blogs/qlikviewdesignblog/2013/07/07/automatic-number-interpretation">http://community.qlik.com/blogs/qlikviewdesignblog/2013/07/07/automatic-number-interpretation</A></P></BODY></HTML> Fri, 26 Jul 2013 09:43:30 GMT swuehl 2013-07-26T09:43:30Z How to get a date difference from today https://community.qlik.com/t5/QlikView/How-to-get-a-date-difference-from-today/m-p/527552#M197142 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a problem creating a field the shows me the difference in days between a field and the current date. Can someone please help me with this?</P><P></P><P>I have Now()-Createdate</P><P></P><P>but is does not work.</P><P></P><P>Simon</P></BODY></HTML> Fri, 26 Jul 2013 09:22:41 GMT https://community.qlik.com/t5/QlikView/How-to-get-a-date-difference-from-today/m-p/527552#M197142 2013-07-26T09:22:41Z Re: How to get a date difference from today https://community.qlik.com/t5/QlikView/How-to-get-a-date-difference-from-today/m-p/527553#M197143 <HTML><HEAD></HEAD><BODY><P>Simon, </P><P></P><P>you probably need to interpret your Createdate as date, so QV assings a numeric value representation to the value, thus allowing Now() - Createdate to return the number of days.</P><P></P><P>Please check</P><P><A _jive_internal="true" class="loading active_link" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/02/19/why-don-t-my-dates-work" title="http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/19/why-don-t-my-dates-work">http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/19/why-don-t-my-dates-work</A></P><P><A _jive_internal="true" class="loading" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/07/07/automatic-number-interpretation" title="http://community.qlik.com/blogs/qlikviewdesignblog/2013/07/07/automatic-number-interpretation">http://community.qlik.com/blogs/qlikviewdesignblog/2013/07/07/automatic-number-interpretation</A></P></BODY></HTML> Fri, 26 Jul 2013 09:43:30 GMT https://community.qlik.com/t5/QlikView/How-to-get-a-date-difference-from-today/m-p/527553#M197143 swuehl 2013-07-26T09:43:30Z Re: How to get a date difference from today https://community.qlik.com/t5/QlikView/How-to-get-a-date-difference-from-today/m-p/527554#M197144 <HTML><HEAD></HEAD><BODY><P>Try this.</P><P></P><P>Today()-Date(Createdate)</P><P></P><P>Now()- is returns date with full timestamp MM-DD-YYYY hh:mm:ss ffff</P><P>today() - is returns MM-DD-YYYY</P><P></P><P>Regards,</P><P>Kabilan K.</P></BODY></HTML> Fri, 26 Jul 2013 09:51:52 GMT https://community.qlik.com/t5/QlikView/How-to-get-a-date-difference-from-today/m-p/527554#M197144 2013-07-26T09:51:52Z