copy same value to another column

[aminsaleh]

Hi there,

I have a table called orders. Inside it there are two columns of type date.

>> Fulfillment date

>> Task date

I want the initial value for  the task date to copy the same date of the fulfillment date. I have tried this but has not made any change. [Fulfilment Date]. 

also note I should be also able to modify the task date manually if I need to.

Thanks indeed

[AleksiAlkio · Accepted solution]

Your formula is correct with the initial value, but it only affects when you add a new record and you don't touch that field before the original date column is filled.

[aminsaleh]

@AleksiAlkio  Oh yes that is true. Is there a way to update it even if it's updated again later

[AleksiAlkio]

You could use the option "Reset on edit", but you need to think how to control it.