Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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
Boost 5
Level 7
gkaiseril
Level 7

Likes

13 likes

Total Posts

456 posts

Correct Reply

2 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile

Avatar
Boost 5
Level 7
gkaiseril
Level 7

Likes

13 likes

Total Posts

456 posts

Correct Reply

2 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile
gkaiseril
Level 7

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