Announcements
The Google Cloud Community will be in read-only from July 16 - July 22 as we migrate to a new platform; refer to this community post for more details.

Date and data relation

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

1 1 161
1 REPLY 1

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

Top Labels in this Space