Change date - depending on single select

[mycale]

Hello there

For recurring tasks, I’d like to calculate the data depending on what I select in the single select field. For example:

if “2 weeks” choose the formula which adds 2 weeks to a date or if “1 month” then add 1 month and so on.

Is that possible?

Thank you.

Cheers

Marc

[mycale · Accepted solution]

I figured it out. I’ll add more IF statements as needed:

DATETIME_FORMAT(IF(Interval = “2 weeks”, DATEADD(Auftragsdatum, 2, “week”),IF(Interval = “1 month”, DATEADD(Auftragsdatum, 1, “month”), “”)), “D.M.YYYY”)