https://community.qlik.com/t5/QlikView/DAYS/m-p/1605434#M735929 <P>i always convert days to floor and then do such manipulations.</P><P><SPAN>floor(pol_policy_to_date)-floor(pol_policy_from_date)</SPAN></P> Wed, 24 Jul 2019 05:56:17 GMT fallenangel6 2019-07-24T05:56:17Z https://community.qlik.com/t5/QlikView/DAYS/m-p/1604913#M735927 <P>Dear All</P><P>I have a two field in <FONT color="#FF00FF">pol_policy_from_date and pol_policy_to_date</FONT>. I want a calculate no of days how to do this.</P><P>&nbsp;</P><P>sahara</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/DAYS/m-p/1604913#M735927 sagaraperera 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/DAYS/m-p/1604917#M735928 <P>By simply subtracting two dates you get the the difference in days.</P><P>&nbsp;</P><P>=<SPAN>pol_policy_from_date&nbsp;</SPAN>-<SPAN>pol_policy_to_date</SPAN>, will give you the difference in days.</P> Tue, 23 Jul 2019 05:35:36 GMT https://community.qlik.com/t5/QlikView/DAYS/m-p/1604917#M735928 shiveshsingh 2019-07-23T05:35:36Z https://community.qlik.com/t5/QlikView/DAYS/m-p/1605434#M735929 <P>i always convert days to floor and then do such manipulations.</P><P><SPAN>floor(pol_policy_to_date)-floor(pol_policy_from_date)</SPAN></P> Wed, 24 Jul 2019 05:56:17 GMT https://community.qlik.com/t5/QlikView/DAYS/m-p/1605434#M735929 fallenangel6 2019-07-24T05:56:17Z