Adding days to field

Avatar

Avatar
Validate 1
Level 1
ianp333321
Level 1

Like

1 like

Total Posts

6 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 1
Applaud 5
Affirm 1
View profile

Avatar
Validate 1
Level 1
ianp333321
Level 1

Like

1 like

Total Posts

6 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 1
Applaud 5
Affirm 1
View profile
ianp333321
Level 1

27-04-2017

I'm trying to find a way to have 2 date pickers that work together to show a pay period  based on 1 date selected in a date picker.

1 date picker the user can select a date and the second date picker that auto populates a date that is 14 days after the date selected in date picker 1 

Please and thank you in advance.

Ian.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 1
ianp333321
Level 1

Like

1 like

Total Posts

6 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 1
Applaud 5
Affirm 1
View profile

Avatar
Validate 1
Level 1
ianp333321
Level 1

Like

1 like

Total Posts

6 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 1
Applaud 5
Affirm 1
View profile
ianp333321
Level 1

28-04-2017

I found the answer on another post. The original post was answered by Magus069 and for those looking for this answer I'll share below.

The date field which you want it to be readOnly will need to have the following FormCalc script within the calculate event

if (DateTimeField1.rawValue <> null) then

      Num2Date(Date2Num(DateTimeField1.rawValue,"YYYY-MM-DD") + 2, "YYYY-MM-DD")

else

      null

endif

Answers (0)