InfoPath 2010

Re: How to use custom date pattern?

Jimmy — Wed, 21 Dec 2011 16:45:26 GMT

I believe the pattern you're looking for is this:

\d\d/\d\d/\d\d\d\d

That will ensure that the value is 2 digits, then a slash, 2 more digits, another slash, and then 4 more digits. This means that something like 33/45/6789 would still be treated as valid, but I think that's about the best you can do in this situation. Frankly, this sounds like a bad idea. Allowing the months and days to be in order sounds especially crazy. If you have that many fields, maybe it would make sense to move to a non-list form, which has less limitations?

How to use custom date pattern?

rahulbabar — Wed, 21 Dec 2011 09:28:14 GMT

Hi All,

I need to validate text box for date field. We can not use date field since there are too many date fields on the form and it has exceeded the 48 date column limit.

I am developing infopath 2010 form based on sharepoint list template. The validation rule needs to validate date for dd/mm/yyyy or mm/dd/yyyy but I am not able to get the pattern (Reg. expression) for this.

Most of the times it says like invalid pattern. Is infopath pattern different than regular expression? I appreciate your suggestions.

Thanks,

Rahul Babar