I have a property "Renewal Date" of type Date with an ID of 1308.
I have a property "Is Renewal Date Set" of type Boolean which I want to automatically calculate to Yes/No indicating if there's a date entered in "Renewal Date."
Here's my current script for the calculated value of "Is Renewal Date Set:"
Dim RenewalDate
Dim RenewalDateBool
RenewalDate= PropertyValues.SearchForProperty( 1308 ).TypedValue.DisplayValue
RenewalDateBool=True
If (IsNull(RenewalDate)) then
RenewalDateBool=False
end if
Output = RenewalDateBool
This returns a value of Yes to "Is Renewal Date Set" even if there's nothing in the Renewal Date property. What am I missing?