Hi guys, I have a situation where I need to extract :1) Old status[yesterday 5am] 2) New/updated status [yesterday 5pm]
Database gets updated twice 5am and 5 pm a day;
I have fields : PatientId, VisitStatus and VisitTimestamp;
now my requirement is that I have to distinguish and show the changes happening in status within a single day
Example: old status=Validated ,newstatus=Approved
I hope someone can give me any helpful answer. Thank you!
