nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

regex for a date of birth

ryanEvanczyk

I have a text field with a input mask (99-99-9999) and a hit (mm-dd-yyyy) where user inputs a DOB. This field is then used to calculate the Age of the person.

I'm trying to write a regex so that a month of 13 and day of 32 are not allowed and I can't seem to get the syntax correct in Survey 123 - it appears to be correct in online regex checkers....

The regex is as follows:

regex(.,'^((0[1-9])|(1[12]))-((0[1-9])|(1[\d])|(2[\d])|(3[01]))-([\d]{4})$')

Am I missing something else?

Cheers,

RyanE

Find more posts tagged with

Accepted answers

All comments

BenTurrell

Hey Ryan Evanczyk‌,

I tried out your regex in a super simple Survey123 form and it seems to work fine. I've attached the form. If you can upload your form I can take a look for you.

Thanks,

Ben

If this answer was helpful please mark it as helpful. If this answer solved your question please mark it as the answer to help others who have the same question.

Form 4.xlsx

ryanEvanczyk

Hi Ben,

So frustrating.

I originally had written the regex to be for a dateTime stamp (yyyy-mm-dd hh:mm) and it was working. When I removed the time portion and switched the date around to be mm-dd-yyyy it stopped working.

I've tried every combination I can think of for the regex with different syntax using the online regex checkers. I also tried copying and pasting just the values of the whole surey into a new survey and that also did not work.

The form is attached. Look at line 54.

Thanks for your help,

RyanE

JamesTedrick

Hi Ryan,

Is there a reason you don't want to use a date question? That would seem to be more appropriate than text in a pattern.

ryanEvanczyk

The main reason is that it seemed easier to fill out a text field than the date question. We use web books to complete our forms - generally the user has the computer in their lap while they type. Using the touchpad mouse to adjust the dates (and times) was more difficult for people than just typing in the numbers. Specifically, with the dob question, what was difficult for people was spinning that wheel for the year.

Gerhard

Just came across this, looks like there's a zero for the second month digit which would exclude October.

regex(.,'^((0[1-9])|(1[012]))-((0[1-9])|(1[\d])|(2[\d])|(3[01]))-([\d]{4})$')

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.