| Title |
Test
Find
Pattern Title
|
| Expression |
^(((0[1-9]|[12]\d|3[01])\/(0[13578]|1[02])\/(\d{2}))|((0[1-9]|[12]\d|30)\/(0[13456789]|1[012])\/(\d{2}))|((0[1-9]|1\d|2[0-8])\/02\/(\d{2}))|(29\/02\/((0[48]|[2468][048]|[13579][26])|(00))))$ |
| Description |
Matching : dd/MM/yy
Leap years compatible
Italian style, just for more fun.
Please, don't forget to rate it if you use it. THX
|
| Matches |
31/12/75 | 29/02/00 | 29/02/04 |
| Non-Matches |
01/13/01 | 29/02/01 | 29/02/2004 |
| Author |
Rating:
Not yet rated.
Dany Lauener
|
| Source |
My magic box :) |
| Your Rating |
|
Title: Thanks
Name: Jim
Date: 11/10/2018 7:09:46 AM
Comment:
This one works in Google Sheets with the REGEXMATCH function to find dd/mm/yy values, lovely.
Title: Thanks
Name: Jim
Date: 11/10/2018 5:37:17 AM
Comment:
This one works in Google Sheets with the REGEXMATCH function to find dd/mm/yy values, lovely.
Title: Regex.IsMatch Date Validation....
Name: Jose Gallardo
Date: 3/15/2010 7:19:58 PM
Comment:
I have the followiing statement, but it does not work for 2010....mm/dd/yyyy.
Please help.....
Title: Thanks Dany
Name: Mark
Date: 5/29/2009 9:59:47 AM
Comment:
Well Done. Saved me a job!
