With my little app, i can order products.
I have a Date of order / Date of delivery / Status
Date of order=TODAY()
Date of delivery is valid if >= Date of order
So far, nothing fancy.
However when i change the Status from On order to Delivered (which happens after delivery), it cannot be updated.
Indeed, the update get TODAY() = Date of order > Date of delivery…
Hopefully some of you will have understood me…
Any idea is welcome