Date Calculations

[Slo]

Is infopath able to calculate a date in the future? Problem: I have a form
that requires a date to be entered. Then they have to enter the number of
months. Can I take the date entered and add 12 months and get a valid date?

 

[K.Ramana Reddy(GGK Tech)]

Hi,

which version of infopath you are using infopath 2003 or 2007?

we have one feature in infopath 2007, We can add a specific number of days
to a date and display the results in a control on a form by using the addDays
and today functions.

check out this link,
http://office.microsoft.com/en-us/infopath/HA100360601033.aspx

I hope this will help for you.

 

[Kalyan G Reddy MVP (GGK Tech)]

Hello
Please read the HowTo's at the link below
http://enterprise-solutions.swits.net/infopath2003/

There are lots of them on date and Time Calculations. You can select the one
which suits your need

 

[Kalyan G Reddy MVP (GGK Tech)]

Hello

Also read the link below
http://blogs.msdn.com/infopath/archive/2005/01/25/360318.aspx

 

[Slo]

Thanks for the response. I am using 2007. What I really need is adding
months to a date. Example: Taking a date that was entered with a 'date
picker' field. Then adding a month value that was entered by the user
(example 12 months). Then adding 12 months to the date entered to get the
valid mm/dd/yyyy in the future. I really don't think the 'days' calculation
is going to work for me. Because each month has a different number of days.

 

[S.Y.M. Wong-A-Ton]

You will have to write code for this. The DateTime object in C# and VB.NET
has an addMonths() method that you can use to get the future date you need.

 

[Slo]

Thanks for the response..... That's what I thought....