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...
amitchandak
Super User
Super UserAnonymous , Assume have date in rows and you want to take diff with date in last row for same ID say
new column =
var _max = maxx(filter(Table, [ID] = earlier([ID]) && [Date] < earlier([Date]) ), [Date] )
return
datediff(_max,[Date], day)