Date and data relation

Let Closing Stock value be opening stock value when date changes to next day.
How to do this?

1 Like

Try using if condition which takes 3 inputs, in that keep a condition to find the time difference of 1 day. In "if expression " you will be having another 2 expression based on yes/no output of condition. In those try de-referencing the closing stock value if true. In else expression keep same old value/opening value don’t update.
Just try ,let me know if any issues

Regards,
Srikanth