copy same value to another column

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

Untitled.jpg

Solved Solved
0 3 421
1 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.

View solution in original post

3 REPLIES 3
Top Labels in this Space