Attempting to validate a date field in a SharePoint List Form - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Attempting to validate a date field in a SharePoint List Form

Last post 04-10-2013 04:36 PM by Hilary Stoupa. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 04-10-2013 08:12 AM

    Attempting to validate a date field in a SharePoint List Form

    I have a need to add validation to date field in a list form that will check that the date entered in the date field (which is a date picker), validates that it is not older than one year from what is entered. Meaning today is 4/10/2013 then the date can not be greater than 4/10/2014 , however everytime I add a rule no validation works. I have tried the now(), the today(), the less than the greater than etc.... and nothing seems to work. I relize that infopath holds the date in a different format but that doesn't help with a solution. I can not add customized code to this form and again it is tied to a SP list, so can anyone provide a work around or fix to be able to validate date fields?
  • 04-10-2013 08:26 AM In reply to

    Re: Attempting to validate a date field in a SharePoint List Form

    How are you calculating the comparison date? Are you using addDays()?
    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™


  • 04-10-2013 09:13 AM In reply to

    Re: Attempting to validate a date field in a SharePoint List Form

    I have not tried the adddays()

    I was attempting to create a validation rule, Datefield is greater than or equal to datefield+365

  • 04-10-2013 04:36 PM In reply to

    Re: Attempting to validate a date field in a SharePoint List Form

     To do date math in InfoPath, use the addDays() function. More here.

    Hilary Stoupa

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