Is this a duplicate post from this thread?
I gave you a solution to bulk update fields there.
For step 2, you should think about adding additional search parameters for booth scenarios. When filtering only with status, scenario 1 and scenario 2 will use the same records without distinguishing which are from today and which are from yesterday.
Have a nice day!