Code

Re: Adding dates in infopath 2003

Jimmy — Fri, 08 Oct 2010 02:59:26 GMT

http://www.google.co.jp/search?q=javascript+substring&rls=com.microsoft:en-us&ie=UTF-8&oe=UTF-8&startIndex=&startPage=1&redir_esc=&ei=yoiuTNi6DY_0swO-g_GXDA

InfoPath's dates are always in the format yyyy-mm-dd, so extracting out the three parts should be pretty straightforward.

Re: Adding dates in infopath 2003

codediva — Thu, 07 Oct 2010 19:07:05 GMT

Jimmy,

I guess my question is how do I take that date value entered in the form and "parse out the individual parts"?

Re: Adding dates in infopath 2003

Jimmy — Thu, 07 Oct 2010 16:31:34 GMT

Please disregard my earlier post if you've already read it. I didn't notice you're using IP 2003.

To the best of my recollection, the JScript Date() constructor does not accept dates in ISO (yyyy-mm-dd) format. You need to parse out the individual parts and call the Date constructor that takes three arguments:

Date(year, month, day)

Once you have your date object and have added 7 days to it, you need to call getYear(), getMonth(), and getDay() to put the date back together as an ISO date string before you try to compare it to your other date value.

Re: Adding dates in infopath 2003

codediva — Thu, 07 Oct 2010 16:26:38 GMT

Thanks Patrick,

I took a look at the 2003 Meeting Agenda template and it looks like it uses comparison of dates, if date 1 < date 2. But I need to add 7 days to my date 1 and then compare the new date value to date 2.

Re: Adding dates in infopath 2003

Patrick Halstead — Wed, 06 Oct 2010 06:57:25 GMT

You can do this without code. Take a look at the Meeting Agenda (Detailed) form template available for free from Microsoft's web site (Google: InfoPath form template Meeting Agenda). There should be a 2003 form available. This form also shipped as one of the 2003 out-of-box solutions - I know because my team built those for the launch of 2003. Anyway, Meeting Agenda has a special rule that checks preceding-sibling and verified that the agenda items don't occur at overlapping times. You can use the same kind of logic to ensure a 7 day span. Using an xpath to add days to your field and compare the dates against that is relatively easy to do. No coding required.

Adding dates in infopath 2003

codediva — Thu, 30 Sep 2010 21:19:48 GMT

I have a check out date and return date on my form. When the user selects the check out date, the form validates that the checkout date entered is no more than 7 days from the current date. Got that piece working fine. When the user selects the return date, I am trying to make the form validate that the return date is no more than 7 days from the selected check out date. Here is what I thought would work:

function msoxd_my_returnDate::OnValidate(eventObj)

{

var formOutDate = XDocument.DOM.selectSingleNode("//my:outDate");

var formReturnDate = XDocument.DOM.selectSingleNode("//my:returnDate");

if (eventObj.Site.nodeTypedValue != "")

{

var myDate = new Date(formOutDate.text);

myDate.setDate(myDate.getDate()+7);

if (myDate < formReturnDate.text)

{

XDocument.UI.Alert("Return date can not be more than 7 days from the checkout date.");

}