How do I code dates within an If Then formula?
I would like to code the following: If the property is in a particular county, the requested tasks due date should be 2 days after requested. Otherwise, it should be 5 days after requested. Please advise.
Thanks.
Formula Editor
Moderator: Phil Barton
Re: Formula Editor
I apologize for the delay. Try this:
Note that a requested task has no explicit relationship with a particular property, so here we assume that it's the first property in the order that should be consulted.
Code: Select all
If ( {{Order.Property[1].County}} == "Wake" ) Then
Value = DateAdd( {{.RequestedDate}}, 2, "d", true )
Else
Value = DateAdd( {{.RequestedDate}}, 5, "d", true )
EndIf
Re: Formula Editor
Thank you very much. That works great!!