Regular Expression for datetime

[=?Utf-8?B?THVpZ2k=?=]

Hi all,
anyone knows a regular expression for this datetime format?

dd/MM/yyyy

Thanks in advance.

--
Luigi

[CreativeMind]

Re: Regular Expression for datetime

On May 12, 5:08 pm, Luigi <ciupazNoSpamGr a...@inwind.itw rote:

Hi all,
anyone knows a regular expression for this datetime format?
>
dd/MM/yyyy
>
Thanks in advance.
>
--
Luigi

Date dd/mm/yyyy
01/01/1900 through 31/12/2099
Matches invalid dates such as February 31st

(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)[0-9]{2}
-------------------------------------
\b(0?[1-9]|[12][0-9]|3[01])[- /.](0?[1-9]|1[012])[- /.](19|20)?[0-9]
{2}\b

[=?Utf-8?B?THVpZ2k=?=]

Re: Regular Expression for datetime

"CreativeMi nd" wrote:

Date dd/mm/yyyy
01/01/1900 through 31/12/2099
Matches invalid dates such as February 31st
>
(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)[0-9]{2}
-------------------------------------
\b(0?[1-9]|[12][0-9]|3[01])[- /.](0?[1-9]|1[012])[- /.](19|20)?[0-9]
{2}\b

Hi,
I've tried your regular expression:

(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)[0-9]{2}
\b(0?[1-9]|[12][0-9]|3[01])[- /.](0?[1-9]|1[012])[- /.](19|20)?[0-9]
{2}\b

but doesn't work.

L

[CreativeMind]

Re: Regular Expression for datetime

1. (0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)[0-9]
{2}
try it again
On May 12, 6:31 pm, Luigi <ciupazNoSpamGr a...@inwind.itw rote:

"CreativeMi nd" wrote:

Date dd/mm/yyyy
01/01/1900 through 31/12/2099
Matches invalid dates such as February 31st

>

(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)[0-9]{2}
-------------------------------------
\b(0?[1-9]|[12][0-9]|3[01])[- /.](0?[1-9]|1[012])[- /.](19|20)?[0-9]
{2}\b

>
Hi,
I've tried your regular expression:
>
(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)[0-9]{2}
\b(0?[1-9]|[12][0-9]|3[01])[- /.](0?[1-9]|1[012])[- /.](19|20)?[0-9]
{2}\b
>
but doesn't work.
>
L

[=?Utf-8?B?THVpZ2k=?=]

Re: Regular Expression for datetime

"CreativeMi nd" wrote:

1. (0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)[0-9]
{2}
try it again

This one works:

(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)[0-9]{2}

but accepts also 31/02/2008, that is not correct.

L

[CreativeMind]

Re: Regular Expression for datetime

On May 12, 7:33 pm, Luigi <ciupazNoSpamGr a...@inwind.itw rote:

"CreativeMi nd" wrote:

1. (0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)[0-9]
{2}
try it again

>
This one works:
>
(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)[0-9]{2}
>
but accepts also 31/02/2008, that is not correct.
>
L

try this:
^(((0?[1-9]|[12]\d|3[01])[\.\-\/](0?[13578]|1[02])[\.\-\/]((1[6-9]|
[2-9]\d)?\d{2}))|((0 ?[1-9]|[12]\d|30)[\.\-\/](0?[13456789]|1[012])[\.\-
\/]((1[6-9]|[2-9]\d)?\d{2}))|((0 ?[1-9]|1\d|2[0-8])[\.\-\/]0?2[\.\-\/]
((1[6-9]|[2-9]\d)?\d{2}))|(29[\.\-\/]0?2[\.\-\/]((1[6-9]|[2-9]\d)?
(0[48]|[2468][048]|[13579][26])|((16|[2468][048]|[3579][26])00)|00)))$

[=?Utf-8?B?THVpZ2k=?=]

Re: Regular Expression for datetime

"CreativeMi nd" wrote:

try this:
^(((0?[1-9]|[12]\d|3[01])[\.\-\/](0?[13578]|1[02])[\.\-\/]((1[6-9]|
[2-9]\d)?\d{2}))|((0 ?[1-9]|[12]\d|30)[\.\-\/](0?[13456789]|1[012])[\.\-
\/]((1[6-9]|[2-9]\d)?\d{2}))|((0 ?[1-9]|1\d|2[0-8])[\.\-\/]0?2[\.\-\/]
((1[6-9]|[2-9]\d)?\d{2}))|(29[\.\-\/]0?2[\.\-\/]((1[6-9]|[2-9]\d)?
(0[48]|[2468][048]|[13579][26])|((16|[2468][048]|[3579][26])00)|00)))$
>

This is better ;-)
Thanks a lot.

Luigi