Force Date Chosen to be 'x' days out - InfoPath Dev
in

InfoPath Dev

Force Date Chosen to be 'x' days out

Last post 05-25-2012 10:21 AM by Jen B. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 05-24-2012 03:32 PM

    Force Date Chosen to be 'x' days out

    I swear I did this before using the addDays function, but I can't remember how I did it.  How can I force the date chosen on a date picker to be at least x number of days from the submitted date (which defaults to today())?

    Ideally, I'd like to be able to count only business days as well... i.e. date entered must be at least 10 business days later than the submission date.

    Thanks!

  • 05-24-2012 10:21 PM In reply to

    Re: Force Date Chosen to be 'x' days out

    Without taking business days into account, the following validation rule should work:

    Condition: date [Is less than] (Use a formula...) addDays(submissionDate, 10)

    To take business days into account, I think you'd need something like the DateDiff command in qRules (which has support for business days).  Let me know if you'd like to give that a try.

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
  • 05-25-2012 10:21 AM In reply to

    Re: Force Date Chosen to be 'x' days out

    Thanks Jimmy!  I'd love to be able to take business days into account, but we have some pretty tight controls on what I can actually download in my office.  No admin access to my computer, so very little  is available.  Not sure I'd even be able to use qRules as much as I'd like to.

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