MVC3 RegEx question (c#)

Dev Shed Forums Sponsor:

March 27th, 2012, 10:07 AM

dlopez

Contributing User

Join Date: Oct 2011

Posts: 64

Time spent in forums: 13 h 33 m 11 sec
Reputation Power: 3

MVC3 RegEx question (c#)

Hello all,

I'm attempting to validate the date and time, separately. I think I have it right, but I just want to check my work.

for the time I have:

PHP Code:


		
			
^(?:0?[0-9]|1[0-9]|2[0-3]):[0-5][0-9]:[0-5][0-9]$

for the date I have:

PHP Code:


		
			
^(?:2?[0-9][0-9][0-9]):[0-1][0-2]:(0?[1-9]|1[0-9]|2[0-9]|3[0-1])$

Could anyone help verify this?

Thanks!

March 27th, 2012, 12:57 PM

requinix

Still alive

Join Date: Mar 2007

Location: Washington, USA

Posts: 12,702

Folding Points: 417516 Folding Title: Super Ultimate Folder - Level 1

Time spent in forums: 5 Months 1 Week 4 Days 5 h 32 m 15 sec
Reputation Power: 8969

Send a message via Google Talk to requinix

Those can be simplified.

Code:

time ^([01]?\d|2[0-3]):[0-5]\d:[0-5]\d$
date ^[12]\d\d\d:(0\d|1[012]):([012]\d|3[01])$

(\d is equivalent to [0-9])

The time one is perfect but the date one requires more validation.

__________________
Site rules and FAQ | Project Suggestions | mod_rewrite guide | PHP New User Guide and FAQ - PHP Stickies | Regex Resources

March 28th, 2012, 11:05 AM

dlopez

Contributing User

Join Date: Oct 2011

Posts: 64

Time spent in forums: 13 h 33 m 11 sec
Reputation Power: 3

Quote:

Originally Posted by requinix

Those can be simplified.

Code:

time ^([01]?\d|2[0-3]):[0-5]\d:[0-5]\d$
date ^[12]\d\d\d:(0\d|1[012]):([012]\d|3[01])$

(\d is equivalent to [0-9])

The time one is perfect but the date one requires more validation.

PHP Code:


		
			
^[12]\d\d\d:(0\d|1[012]):([012]\d|3[01])$

Will this be military format, though? If not, how would I know the difference in AM or PM? I've always just used military time to calculate. also, I'm trying to get the format in YYYY-MM-DD. I'm used to MySQL style databases, but I'm switching to the .Net world and working with SQL Server 2008, now.

*** This is an MVC3 app, also. Just throwing that out there.

March 28th, 2012, 01:48 PM

requinix

Still alive

Join Date: Mar 2007

Location: Washington, USA

Posts: 12,702

Time spent in forums: 5 Months 1 Week 4 Days 5 h 32 m 15 sec
Reputation Power: 8969

That's the date regex.

As YYYY-MM-DD it would look like the same but with hyphens instead of colons.

MVC3 RegEx question (c#)

Developer Shed Advertisers and Affiliates