This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I need to determine the elapsed time from case start date to case close date for each unique case ID. Case ID, DateTime, and Description are in separate columns. Looking for recommendation on the best method to calculate elapsed time between the highlighted values for each case ID. Ideally I would do this by adding another column for the calculated "Time To Close" and put this value in every row with "CLOSE_CASE_EVENT" in the OBJCT_OPER_DESC column.