SoftPro Developer Forum

Posted: **Mon Jul 04, 2011 2:16 am**

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.

Posted: **Fri Jul 08, 2011 10:03 am**

I apologize for the delay. Try this:

Code: Select all

If ( {{Order.Property[1].County}} == "Wake" ) Then
	Value = DateAdd( {{.RequestedDate}}, 2, "d", true )
Else
	Value = DateAdd( {{.RequestedDate}}, 5, "d", true )
EndIf

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.

Posted: **Mon Jul 11, 2011 2:58 am**

Thank you very much. That works great!!

SoftPro Developer Forum

Formula Editor

Formula Editor

Re: Formula Editor

Re: Formula Editor