General

Re: Update: InfoPath 2013 Win 7 Issue with Date Picker Regular Expression Validation

Wheels — Fri, 22 Jun 2018 17:52:46 GMT

Hilary Stoupa:
Great job getting it working & thanks for updating with what works to help others!

My pleasure. Sharing is caring. WHEELS

Re: Update: InfoPath 2013 Win 7 Issue with Date Picket Regular Expression Validation

Hilary Stoupa — Mon, 18 Jun 2018 18:52:06 GMT

Great job getting it working & thanks for updating with what works to help others!

Re: Update: InfoPath 2013 Win 7 Issue with Date Picket Regular Expression Validation

Wheels — Mon, 18 Jun 2018 18:44:00 GMT

I got it working. I used the following: ^((19|20)[0-9][0-9])-(0?[1-9]|1[012])-([1]|0[1]) Although the '$' at the end works online, in InfoPath it was throwing it off initially.Thanks again Hilary. WHEELS

Re: Update: InfoPath 2013 Win 7 Issue with Date Picket Regular Expression Validation

Wheels — Mon, 18 Jun 2018 17:47:45 GMT

Hi Hilary. This is on a date field, and sometimes I forget about the XML date format. I'll alter the RegEx, and see what happens. Thank you. WHEELS

Re: Update: InfoPath 2013 Win 7 Issue with Date Picket Regular Expression Validation

Hilary Stoupa — Mon, 18 Jun 2018 17:21:15 GMT

XML stores dates as yyyy-MM-dd, so your regex will need to take that into account. Is this on a date field?

Update: InfoPath 2013 Win 7 Issue with Date Picket Regular Expression Validation

Wheels — Mon, 18 Jun 2018 15:48:18 GMT

I also tried to set up a Validation rule. Under the Condition I select the field, does not match pattern, Custom Pattern: ^(0?[1-9]|1[012])/([1]|0[1])/((19|20)[0-9][0-9])$, and it lists it as Custom Pattern: 01/1/1900$. When I preview the form, no date is valid.

WHEELS

InfoPath 2013 Win 7 Issue with Date Picket Regular Expression Validation

Wheels — Mon, 18 Jun 2018 15:08:11 GMT

Good morning.

I set up a Regular Expression on a Date Picker control by going to the Date Picker Properties --> Advanced (tab) --> Input Scope --> Custom --> New --> Input Scope --> Name: Validation, Type: Regular Expression, Regular Expression: ^(0?[1-9]|1[012])/([1]|0[1])/((19|20)[0-9][0-9])$ --> OK --> Checked Recognized non-matching input --OK.

I am looking to only allow the user to enter dates that are the 1st of each month, and all others would highlight red as incorrect.

It states that incorrect RegEx will be ignored, but I verified it from the following site: http://regex-testdrive.com/en/dotest

Thank you, WHEELS.