Skip to main content
Solved

Change date - depending on single select

  • October 8, 2019
  • 1 reply
  • 18 views
M

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

Best answer by mycale

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”)

1 reply

M
  • mycale
  • Author
  • New Participant
  • Answer
  • October 8, 2019

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”)

Terms & ConditionsAccessibility statement