Assistance with VBScript to Caculate a value

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?

Parents Reply Children
No Data