Newbie Questions

Re: Calculations to a Date Picker

jhelfrich — Wed, 12 May 2010 15:13:29 GMT

Actually....I got it.

I inserted a date picker labeled projectDueDate and set the value for today().

Created a rule with the condition that if projectDueDate is equal to today() Set that fields value to addDays(today(), 42)

That works.

Thanks to all for input!

Re: Calculations to a Date Picker

Jimmy — Wed, 12 May 2010 14:54:32 GMT

Browser compatible forms should be able to use Form Open rules.

Re: Calculations to a Date Picker

jhelfrich — Wed, 12 May 2010 14:45:16 GMT

I am unable to create a rule on open, this is a browser compatible form.

Re: Calculations to a Date Picker

Qazi Anis — Wed, 12 May 2010 05:37:00 GMT

create a field say firsttime, initially it will be blank.

on open and save write a rule

if firsttime is blank

set the value of your calendar control to addDays(today(), 42)

set firstvalue to "secondtime"

Re: Calculations to a Date Picker

bryanstrader — Tue, 11 May 2010 23:37:38 GMT

Can you access the node that stores the date and use a .setvalue(DateTime.Today.AddDays(42));

Maybe behind the form_load event?

Calculations to a Date Picker

jhelfrich — Tue, 11 May 2010 22:20:22 GMT

All I want to do is have a date picker set to returns todays date and add 6 weeks to it automatically when a new form is created. So if they fill out a new form on 5/11/2010...I want the date picker to show 6/22/2010 with the ability to edit the date before submission.