https://community.qlik.com/t5/QlikView/Strange-calculate/m-p/1742325#M453040 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/6307">@johnan</a>&nbsp;</P><P>and 411 days or 317 corresponds to what ?</P> Wed, 09 Sep 2020 09:22:09 GMT Taoufiq_Zarra 2020-09-09T09:22:09Z https://community.qlik.com/t5/QlikView/Strange-calculate/m-p/1742308#M453039 <P>Hi, i have (i think) a date like this:</P><P>1754-02-16 00:00:00</P><P>How can i calculate in QV so it's shows 411 days??</P><P>Or<BR />1753-11-14 00:00:00 = 317 days<BR />I'm stucked here bigtime <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Sat, 16 Nov 2024 18:07:52 GMT https://community.qlik.com/t5/QlikView/Strange-calculate/m-p/1742308#M453039 johnan 2024-11-16T18:07:52Z https://community.qlik.com/t5/QlikView/Strange-calculate/m-p/1742325#M453040 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/6307">@johnan</a>&nbsp;</P><P>and 411 days or 317 corresponds to what ?</P> Wed, 09 Sep 2020 09:22:09 GMT https://community.qlik.com/t5/QlikView/Strange-calculate/m-p/1742325#M453040 Taoufiq_Zarra 2020-09-09T09:22:09Z https://community.qlik.com/t5/QlikView/Strange-calculate/m-p/1742339#M453041 <P>I'll be back, i don't even know yet <span class="lia-unicode-emoji" title=":face_with_tears_of_joy:">😂</span></P><P>I could be todays date, it's regardning Exipredays</P> Wed, 09 Sep 2020 09:56:49 GMT https://community.qlik.com/t5/QlikView/Strange-calculate/m-p/1742339#M453041 johnan 2020-09-09T09:56:49Z https://community.qlik.com/t5/QlikView/Strange-calculate/m-p/1744254#M453142 <P>Hi, okay this is the solution, It comapres the lowest datetime in MS-SQL (1753-01-01) to 1753-11-14, and it's 311 days.</P><P>Strange way to calculate, but it works <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Wed, 16 Sep 2020 10:48:16 GMT https://community.qlik.com/t5/QlikView/Strange-calculate/m-p/1744254#M453142 johnan 2020-09-16T10:48:16Z