Infopath 2007: Auto calculate 3mths from another date field - InfoPath Dev
in

InfoPath Dev

Infopath 2007: Auto calculate 3mths from another date field

Last post 09-16-2011 06:09 AM by jamtin. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 09-08-2011 05:52 AM

    • jamtin
    • Not Ranked
      Female
    • Joined on 09-08-2011
    • Australia
    • Posts 6

    Infopath 2007: Auto calculate 3mths from another date field

    Hi Guys, Another question for you.. I have two fields around my employee probation form. The employee's probation is done in 2 parts - one at 3, and one at 6mths.. Rather than having to enter two dates exactly 3mths apart, is there a formula I can use to add 3 months? I saw the addDays, but as we don't have exactly the same number of days in a month, that doesn't work for me.. :) Ta! Jami
  • 09-15-2011 07:59 AM In reply to

    • eliasen
    • Top 500 Contributor
      Male
    • Joined on 10-07-2010
    • Aalborg, Denmark
    • Posts 33

    Re: Infopath 2007: Auto calculate 3mths from another date field

    Hi

    Could you be specific about the algorithm you want to implement?

    What do you expect to happen if you add 3 months to November 30'th 2010 ? Which date should that end up at when adding three months? February 29'th 2011? March 2'nd 2011?

    Thanks

    eliasen, representing himself and not the company he works for.
    Microsoft BizTalk MVP
    Blog: http://blogs.eliasen.dk/technical/
  • 09-16-2011 06:09 AM In reply to

    • jamtin
    • Not Ranked
      Female
    • Joined on 09-08-2011
    • Australia
    • Posts 6

    Re: Infopath 2007: Auto calculate 3mths from another date field

    hmmm good thinking eliasen.. I didn't think of that. In this case, it would be the next day, so when adding 3 months and the date doesn't exist (such as 31st month), it will fall to the 1st of the next month.. Sorry! I'm still new at all this stuff :) Jami
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.