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

Matt

0 2 98
2 REPLIES 2

You probably should be using Initial Value instead of App Formula

Cheers.
Will try this

Top Labels in this Space