Forum Discussion
Solved
Work out dates between one column on multi rows
Hi, I have a table 'audit' containing all the different stages of an appeal. I need to work out the dates between the date the status was changed but I am struggling without a start date. ...
In the attached, the same query adapted to a changed column name from Date Notified to createdon.
It produces just short of 900k rows so I've reduced it to one row (to be able to attach it here) which means you'll need to refresh the query to see those rows. it takes a few seconds to generate those rows…
Nearly there… this needs a login; can you make it available to all or share elsewhere please?
