topic Date/Time Calculation Question in QlikView https://community.qlik.com/t5/QlikView/Date-Time-Calculation-Question/m-p/150287#M28339 <HTML><HEAD></HEAD><BODY><P>How about:</P><P>RangeMax([HR Approval Date/Time 1],<BR />[HR Approval Date/Time 2],<BR />[HR Approval Date/Time 3],<BR />[HR Approval Date/Time 4]) - [Origination Date/Time]</P><P></P><P>-Rob</P></BODY></HTML> Fri, 24 Jul 2009 23:15:05 GMT rwunderlich 2009-07-24T23:15:05Z Date/Time Calculation Question https://community.qlik.com/t5/QlikView/Date-Time-Calculation-Question/m-p/150286#M28338 <HTML><HEAD></HEAD><BODY><P>I have to calculate the amount of hours that a request takes to move through our system. I have several Date/Time fields to use in my calculation (formatted as YYYY-MM-DD HH:MM:SS). These are the fields I am using:</P><P>Origination Date/Time</P><P>HR Approval Date/Time 1</P><P>HR Approval Date/Time 2</P><P>HR Approval Date/Time 3</P><P>HR Approval Date/Time 4</P><P>I need the difference between the last HR Approval we have received and the Origination Date/Time. I know it's the difference between the Approval and Origination fields, but I'm not sure how to take into account that it can be any of the 4 approval fields. I hope this makes sense!</P><P>Thanks,</P><P>Jennifer</P></BODY></HTML> Fri, 24 Jul 2009 22:30:29 GMT https://community.qlik.com/t5/QlikView/Date-Time-Calculation-Question/m-p/150286#M28338 2009-07-24T22:30:29Z Date/Time Calculation Question https://community.qlik.com/t5/QlikView/Date-Time-Calculation-Question/m-p/150287#M28339 <HTML><HEAD></HEAD><BODY><P>How about:</P><P>RangeMax([HR Approval Date/Time 1],<BR />[HR Approval Date/Time 2],<BR />[HR Approval Date/Time 3],<BR />[HR Approval Date/Time 4]) - [Origination Date/Time]</P><P></P><P>-Rob</P></BODY></HTML> Fri, 24 Jul 2009 23:15:05 GMT https://community.qlik.com/t5/QlikView/Date-Time-Calculation-Question/m-p/150287#M28339 rwunderlich 2009-07-24T23:15:05Z