Date/Time Validation regex problem

Monil

I am trying to add validation regex to Metadata capture to validate Date/Time in this format - YYYY-MM-DDThh:mm±TZD. for eg - 2004-03-16T16:51-05:00 (with no spaces, no extra characters)

The following regex works for Date and does not allow spaces or extra characters (eg: 2004 -03-16 is correctly marked as invalid) -
validation-regex="((19|20)[0-9][0-9]-(((01|03|05|07|08|10|12)-((0[1-9])|([12][0-9])|(3[01])))|((04|06|09|11)-((0[1-9])|([12][0-9])|(30)))|(02-((0[1-9])|(1[0-9])|(2[0-8])))))|((19|20)(((04|08))|((2|4|6|8)(0|4|8))|((1|3|5|7|9)(2|6)))-02-29)"

But when I add the following time validation regex -
T[0-2]:[0-5](:[0-5])?[+\-][0-1]:[0|3]0

time validation does not work, while date still works. Would appreciate anyone helping me with the time validation regex.

Adam Stoller

Try this:
validation-regex="((19|20)[0-9][0-9]-(((01|03|05|07|08|10|12)-((0[1-9])|([12][0-9])|(3[01])))|((04|06|09|11)-((0[1-9])|([12][0-9])|(30)))|(02-((0[1-9])|(1[0-9])|(2[0-8]))))T(([01][0-9])|(2[0-3]))[0-5][0-9])[\-\+]((0[0-9])|(1[0-2])):[03]0)|((19|20)(((04|08))|((2|4|6|8)(0|4|8))|((1|3|5|7|9)(2|6)))-02-29T(([01][0-9])|(2[0-3]))[0-5][0-9])[\-\+]((0[0-9])|(1[0-2])):[03]0)"

--fish
Senior Consultant, Quotient Inc.
http://www.quotient-inc.com