I have a formula field that gives me a date.
then I have a normal date field "current". For example, if I enter a date in the "Current" date field, then the formula field should calculate 2 years from this date and give me the date in 2 years
Example: “current” has the value: October 1st, 2020
Formula field calculates 2 years further
10/1/2022
works quite well so far
If the “current” field is empty then the formula field should take the date of “approval” and calculate 3 years from there.
Example:
“Approval” has the value: October 1st, 2017 then the formula field calculates 3 years further so: October 1st, 2020 also works.
but every time this formula is executed, I get a linked table
a new data set is simply created even though this is not what is wanted.
here is my formula:
DATETIME_FORMAT(IF({Letzter HU/ AU Termin}, DATEADD({Letzter HU/ AU Termin}, 2, 'years'), DATEADD({Erstzulassung}, 3, 'years')), 'MM.YYYY')