Freeze a date of order with TODAY() formula

Hi all,

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


You probably should be using Initial Value instead of App Formula


Will try this

1 Like