Expand my Community achievements bar.

How to get the calculation to remain blank until user inputs date calculation is relying on??

Avatar

Former Community Member
I have the following calculation in my form but I cannot figure out how to get Date3 to remain blank until the user inputs Date2??? Any help??



if (Date2.formattedValue ne null) then

Num2Date(Date2Num(Date2.formattedValue, "MM/DD/YYYY") + 14, "MM/DD/YYYY")

else

null

endif
2 Replies

Avatar

Level 7
Use FormCalc's "HasValue(v1)" funciton.

Avatar

Former Community Member
I placed the following in the initialize section of Date3 and it still wasn't working. I know I am just doing something dumb.



Date2 HasValue("MM/DD/YYYY")