Date Calculations in InfoPath 2003 - InfoPath Dev
in

InfoPath Dev

Date Calculations in InfoPath 2003

Last post 03-19-2012 12:40 PM by dustbin111. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 03-19-2012 11:07 AM

    Date Calculations in InfoPath 2003

    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?

  • 03-19-2012 12:18 PM In reply to

    Re: Date Calculations in InfoPath 2003

    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?
    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
  • 03-19-2012 12:40 PM In reply to

    Re: Date Calculations in InfoPath 2003

    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...

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.