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

Avatar

30-05-2008

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

Replies

Avatar

Avatar

gkaiseril

Avatar

gkaiseril

gkaiseril

30-05-2008

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

Avatar

02-06-2008

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")