validation-regex date + optional time

Melle

I am trying to check the contents of a text-field, to make sure that it has a proper date entered, and optionally a time stamp.

This means that users should be able to enter the following format "yyyy-mm-dd( hh:mm)". For example, both "2003-06-12" and "2003-06-12 11:48" should be accepted.

I've tried it with the following validation-regexp, but to no avail: "^[0-9][0-9][0-9][0-9]-[0-1][0-9]-[0-3][0-9]( [0-2][0-9]:[0-5][0-9])?$".

The following does work, but makes the timestamp mandatory, which it shouldn't be: "^[0-9][0-9][0-9][0-9]-[0-1][0-9]-[0-3][0-9] [0-2][0-9]:[0-5][0-9]$".

Any help would be greatly appreciated.

Regards,
Melle de Wit

Adam Stoller

First - you might want to look at a better regex for date validation (KB 45818)

However - using yours as an example - I believe what you need is something that looks more like this:
"^([0-9]{4}-[01][0-9]-[0-3][0-9]|[0-9]{4}-[01][0-9]-[0-3][0-9] [0-2][0-9]:[0-5][0-9])$"
Alternatively, if templating regex's understand \d - it becomes:
"^(\d{4}-[01]\d-[0-3]\d|\d{4}-[01]\d-[0-3]\d [0-2]\d:[0-5]\d)$"

--fish
(Interwoven Senior Technical Consultant)