Newbie Questions

Re: Date fields validation

Jimmy — Wed, 11 Apr 2012 05:50:54 GMT

How about something like this:

translate(substring(firstDate, 1, 10), '-', '') > translate(substring(secondDate, 1, 10), '-', '')

Re: Date fields validation

Voicenat — Wed, 11 Apr 2012 00:57:08 GMT

Hi Hilary

I am trying to use a similar validation were the date can not be "less than" the date the form was created. Which works fine if it is not equal to the date the form was created. When this scenario occurs I recieve the validation msg I want the user to be able to use a date that is equal to. do you have any tips on a work around.

Re: Date fields validation

SWAM — Wed, 27 Oct 2010 09:04:39 GMT

Thanks Hilary for your hints. Now it works the way i want.

Take Care

Re: Date fields validation

Hilary Stoupa — Tue, 26 Oct 2010 15:00:01 GMT

Hi -- you can add validation to both the Start and the End date fields. Right click on the field in the data source task pane and select properties. Under the Validation tab (if you are using IP 2010, I think this may be under rules, so you'll need to click the Manage Rules button for the field instead of the properties) you can add validation rules. For end date, for example, the rule would have the conditions Start is not blank and Start is not less than End. You can enter the error message you'll show the user, and even pop up an error message!

Date fields validation

SWAM — Tue, 26 Oct 2010 12:47:22 GMT

Hello there,

I have created a form, which havetwo date fields. I want to make sure that Staring date is always less than End date. Any one have a smart idea, as i am new to InfoPath.

Thanks.