topic Re: Elapsed time calcualtion in QlikView https://community.qlik.com/t5/QlikView/Elapsed-time-calcualtion/m-p/1152930#M912925 <HTML><HEAD></HEAD><BODY><P>In your load script? I'm assuming that the unspecified character string CASE_OPEN_DTTM is the name of a field containing a regular date? Then you can use:</P><P></P><P><SPAN style="font-family: 'courier new', courier;">LOAD</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp; : </SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp; Floor(today() - CASE_OPEN_DTTM) As NoOfDays,</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp; :</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">FROM sourcefile.</SPAN></P><P></P><P>Best,</P><P></P><P>Peter</P></BODY></HTML> Thu, 26 May 2016 15:30:35 GMT Peter_Cammaert 2016-05-26T15:30:35Z Elapsed time calcualtion https://community.qlik.com/t5/QlikView/Elapsed-time-calcualtion/m-p/1152929#M912924 <HTML><HEAD></HEAD><BODY><P>Can some one please tell me how to calculate the number of days between today's date and a previous date, such as "CASE_OPEN_DTTM""</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Elapsed-time-calcualtion/m-p/1152929#M912924 2020-11-25T16:16:04Z Re: Elapsed time calcualtion https://community.qlik.com/t5/QlikView/Elapsed-time-calcualtion/m-p/1152930#M912925 <HTML><HEAD></HEAD><BODY><P>In your load script? I'm assuming that the unspecified character string CASE_OPEN_DTTM is the name of a field containing a regular date? Then you can use:</P><P></P><P><SPAN style="font-family: 'courier new', courier;">LOAD</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp; : </SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp; Floor(today() - CASE_OPEN_DTTM) As NoOfDays,</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp; :</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">FROM sourcefile.</SPAN></P><P></P><P>Best,</P><P></P><P>Peter</P></BODY></HTML> Thu, 26 May 2016 15:30:35 GMT https://community.qlik.com/t5/QlikView/Elapsed-time-calcualtion/m-p/1152930#M912925 Peter_Cammaert 2016-05-26T15:30:35Z Re: Elapsed time calcualtion https://community.qlik.com/t5/QlikView/Elapsed-time-calcualtion/m-p/1152931#M912926 <HTML><HEAD></HEAD><BODY><P>In addition to what <A _jive_internal="true" href="https://community.qlik.com/people/pcammaert">Peter</A>‌ mentioned, you can also:</P><P></P><UL><LI>Use Interval() if you need hours and minutes</LI></UL><P><STRONG>Interval(Now() - CASE_OPEN_DTTM, 'D hh:mm:ss') as TimeBetween</STRONG></P><P></P><UL><LI>Use you need just the working days, you can use NetWorkingDays</LI></UL><P><STRONG>NetWorkDays(</STRONG><STRONG style="font-size: 13.3333px;">CASE_OPEN_DTTM, Today()) as NetWorkDaysBetween</STRONG></P></BODY></HTML> Thu, 26 May 2016 16:22:24 GMT https://community.qlik.com/t5/QlikView/Elapsed-time-calcualtion/m-p/1152931#M912926 sunny_talwar 2016-05-26T16:22:24Z