topic Re: Dates as consecutive numbers in QlikView https://community.qlik.com/t5/QlikView/Dates-as-consecutive-numbers/m-p/564922#M1105071 <HTML><HEAD></HEAD><BODY><P>No, I mean what kind of compatibility problems do we have to deal with ? I don't really use excel so I don't know.</P></BODY></HTML> Fri, 28 Mar 2014 18:28:02 GMT 2014-03-28T18:28:02Z Dates as consecutive numbers https://community.qlik.com/t5/QlikView/Dates-as-consecutive-numbers/m-p/564917#M1105063 <HTML><HEAD></HEAD><BODY><P>The book Qlikview 11 for developers says - </P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">"</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">Once the corresponding date value has been obtained, it is then converted to its</SPAN></P><P>numerical representation (which is the number of days that have passed since</P><P>December 31, 1899) using the&nbsp; Num() function. For instance, December 28, 2011,</P><P>would be converted to 40905. <STRONG>This ensures that all of the dates can be treated as</STRONG></P><P><STRONG>consecutive numbers.</STRONG><SPAN style="font-size: 10pt; line-height: 1.5em;">"</SPAN></P><P></P><P>Why should we treat dates as consecutive numbers ?</P><P></P><P>Thank you.</P></BODY></HTML> Wed, 26 Mar 2014 20:46:43 GMT https://community.qlik.com/t5/QlikView/Dates-as-consecutive-numbers/m-p/564917#M1105063 2014-03-26T20:46:43Z Re: Dates as consecutive numbers https://community.qlik.com/t5/QlikView/Dates-as-consecutive-numbers/m-p/564918#M1105065 <HTML><HEAD></HEAD><BODY><P>Reason 1 - sorting</P><P>Reason 2 - compatibility with Excel</P><P><BR /> </P></BODY></HTML> Wed, 26 Mar 2014 20:49:16 GMT https://community.qlik.com/t5/QlikView/Dates-as-consecutive-numbers/m-p/564918#M1105065 Anonymous 2014-03-26T20:49:16Z Re: Dates as consecutive numbers https://community.qlik.com/t5/QlikView/Dates-as-consecutive-numbers/m-p/564919#M1105066 <HTML><HEAD></HEAD><BODY><P>date arithmetic (difference between dates)</P></BODY></HTML> Wed, 26 Mar 2014 20:49:40 GMT https://community.qlik.com/t5/QlikView/Dates-as-consecutive-numbers/m-p/564919#M1105066 maxgro 2014-03-26T20:49:40Z Re: Dates as consecutive numbers https://community.qlik.com/t5/QlikView/Dates-as-consecutive-numbers/m-p/564920#M1105068 <HTML><HEAD></HEAD><BODY><P>Yes, sorting int could be faster than date. But, what is the reason for the second point ?</P><P></P><P>Thanks.</P></BODY></HTML> Wed, 26 Mar 2014 21:25:45 GMT https://community.qlik.com/t5/QlikView/Dates-as-consecutive-numbers/m-p/564920#M1105068 2014-03-26T21:25:45Z Re: Dates as consecutive numbers https://community.qlik.com/t5/QlikView/Dates-as-consecutive-numbers/m-p/564921#M1105069 <HTML><HEAD></HEAD><BODY><P>Because making it incompatible with Excel would be a high crime <IMG src="https://community.qlik.com/legacyfs/online/emoticons/devil.png" /></P></BODY></HTML> Thu, 27 Mar 2014 10:51:45 GMT https://community.qlik.com/t5/QlikView/Dates-as-consecutive-numbers/m-p/564921#M1105069 Anonymous 2014-03-27T10:51:45Z Re: Dates as consecutive numbers https://community.qlik.com/t5/QlikView/Dates-as-consecutive-numbers/m-p/564922#M1105071 <HTML><HEAD></HEAD><BODY><P>No, I mean what kind of compatibility problems do we have to deal with ? I don't really use excel so I don't know.</P></BODY></HTML> Fri, 28 Mar 2014 18:28:02 GMT https://community.qlik.com/t5/QlikView/Dates-as-consecutive-numbers/m-p/564922#M1105071 2014-03-28T18:28:02Z