Calculations to a Date Picker - InfoPath Dev Sign in | Join | Help in Newbie Questions InfoPath (Entire Site) InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads InfoPath Dev » InfoPath » Newbie Questions » Calculations to a Date Picker Use our Google Custom Search for best site search results. Calculations to a Date Picker Last post 05-12-2010 08:13 AM by jhelfrich. 5 replies. Page 1 of 1 (6 items) Sort Posts: Oldest to newest Newest to oldest Previous Next 05-11-2010 03:20 PM jhelfrich Joined on 04-27-2009 Posts 12 Calculations to a Date Picker Reply Contact 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. 05-11-2010 04:37 PM In reply to bryanstrader Joined on 04-19-2010 Phoenix, AZ Posts 22 Re: Calculations to a Date Picker Mark as Not AnswerMark as Answer... Reply Contact Can you access the node that stores the date and use a .setvalue(DateTime.Today.AddDays(42)); Maybe behind the form_load event? Bryan StraderSoftware Developer 05-11-2010 10:37 PM In reply to Qazi Anis Joined on 03-13-2009 Chicago Posts 1,025 Re: Calculations to a Date Picker Mark as Not AnswerMark as Answer... Reply Contact 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" Qazi AnisTechnical ArchitectBitwise Inc 05-12-2010 07:45 AM In reply to jhelfrich Joined on 04-27-2009 Posts 12 Re: Calculations to a Date Picker Mark as Not AnswerMark as Answer... Reply Contact I am unable to create a rule on open, this is a browser compatible form. 05-12-2010 07:54 AM In reply to Jimmy Joined on 07-03-2008 Posts 2,594 Re: Calculations to a Date Picker Mark as Not AnswerMark as Answer... Reply Contact Browser compatible forms should be able to use Form Open rules. Jimmy Rishe / Software Developer / Microsoft MVPQdabra Software 05-12-2010 08:13 AM In reply to jhelfrich Joined on 04-27-2009 Posts 12 Re: Calculations to a Date Picker Mark as Not AnswerMark as Answer... Reply Contact 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! Page 1 of 1 (6 items) Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.
Use our Google Custom Search for best site search results.
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.
Can you access the node that stores the date and use a .setvalue(DateTime.Today.AddDays(42));
Maybe behind the form_load event?
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"
I am unable to create a rule on open, this is a browser compatible form.
Browser compatible forms should be able to use Form Open rules.
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!