Date Field Validation - InfoPath Dev
in

InfoPath Dev

Date Field Validation

Last post 06-22-2011 08:34 AM by jbegic. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next

  • 06-16-2011 10:29 AM

    • jbegic
    • Not Ranked
      Male
    • Joined on 06-06-2011
    • Cupertino California
    • Posts 14

    Date Field Validation

    Request.xsn
    Reply Contact
    Hello... I am trying to figure out how to do Date Field Validation on Repeating Table and I can't get it to work.I have two Repeating Tables... The first one has “SupplierDate” and the second repeating table has a “Date” field. What I am trying to do is if “SupplierDate” is set to 6/16/2011, I would like to restrict users from selecting “Date” field to anything that's less than or equal to 6/16/2011 +7 for that row. In other words, user should not be able to select date that's less than 6/24/2011 I have attached InfoPath form here if there are any takers to give it a try.

     

    Thank You
    JBegic

  • 06-16-2011 02:32 PM In reply to

    • jbegic
    • Not Ranked
      Male
    • Joined on 06-06-2011
    • Cupertino California
    • Posts 14

    Re: Date Field Validation

    Mark as Answer
    Reply Contact

    No help needed... Resolved :-)

    Thank You
    JBegic

  • 06-21-2011 04:04 AM In reply to

    Re: Date Field Validation

    Mark as Answer
    Reply Contact

    Hi jbegic,

     

    Just wondering what you did to resolve it?

    Cheers

     

    Jay

  • 06-22-2011 08:34 AM In reply to

    • jbegic
    • Not Ranked
      Male
    • Joined on 06-06-2011
    • Cupertino California
    • Posts 14

    Re: Date Field Validation

    Request.xsn
    Mark as Answer
    Reply Contact
    On the top repeating table, I have created hidden field (field1) and under SupplierDate field I have applied the rule to set a field value "addDays(., 7)" to the Field field1.  On the second Repeating table, I have also created hidden field (field2) and under DVTPartNumber field I have applied the rule to set a field value "field1[SuppliersPartNumber = current()]" to the "field2".  I have also created validation rule to the "Date" field (Date is less than field2) just to highlight invalid date. You can refer to attached file for a sample

     

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