Forum Discussion
Date difference in processing at various phases
Hi Experts, I have about 50 dates in the system from various tables. and I need to find the processing time in days between each VALID time. one way is in T_SQL write 50 times DateDiff or use M o...
Hi amitchandak Yes, I am pulling data from various tables in sql script so should be for each record ID in a row but I am not looking at just days beween max and min, I am looking at transition time between each valid date and map the phase with a look up table which will be given to me later next week.
Also I am not sure, if I understand to map the expression with my 50 days in a row ...
1. [ID] = earlier([ID]) && [Date] < earlier([Date])
2. Is the third parameter output [Date] ?
I was looking for a loop to generate a diff between each date and I will use your formula to show the max days it took from phase 1 to phasse 2 of the system .