I have a list with an editable due date column. I want to be able to conserve the first value saved of the due date column, If the due date value is changed. So I created a second column called DD2 as a calculated field.
For the DD2 column, If I use the formula: =[Due Date] It's going to update [DD2] every time [Due Date] is changed
If I use the formula: =IF(Created=Modified), [Due Date], "") then it works for the new item but all saved items will overwrite DD2 with a blank
If I use the formulate =IF(Created=Modified), [Due Date],) then it works for the new item but all subsequent saved items will overwrite DD2 with an obscure date "12/30/1899".
How can I tell it to make DD2=[Due Date] only when it's a new item, and do nothing otherwise?