Newbie Questions

Re: Date Calculations in InfoPath 2003

dustbin111 — Mon, 19 Mar 2012 19:40:05 GMT

30 days is policy.

BUT, If I increment the month, I'll be right 1/3, right? And it's only a default value --they will change it 90% of the time anyway. Good Call.

Thanks, we'll increment the month and see what the policy boys have to say...

Re: Date Calculations in InfoPath 2003

Jimmy — Mon, 19 Mar 2012 19:18:02 GMT

I doubt that there's a decent codeless way to do this in 2003. Does it have to be 30 days? Would just incrementing the month be sufficient?

Date Calculations in InfoPath 2003

dustbin111 — Mon, 19 Mar 2012 18:07:01 GMT

Using InfoPath 2003, trying to set the default value of a date picker field to +30days of another date field. I cannot use code, must use XPATH or the field function (fx).

I tried something like:

concat(msxsl:format-date(now(), "MM"), "/", msxsl:format-date(now(), "dd") + 30, "/", msxsl:format-date(now(), "yyyy"))

but that didn't work: I does not roll over with the month and I'm getting 3/49/2012.

Any Help?