Regex DateTIme validation

Question

I want to do this in code .cs file

Can some help write a regex datetime validation.

I have two datetime controls, I want to validate that the datetime is a valid date and if not throw and error. I also want to throw an error if the datetime is outside of the range MIN and MAX review below.

MIN date and Max Date
19670101 and 30000101

Jan 01, 1967 and Jan 01, 3000

Vulpes · Answer

Here's an example using DateTime.TryParseExact with the "yyyyMMdd" format which also deals with the minimum and maximum dates: using System; using System.Globalization; using System.Threading; class Test { static void Main() { Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US"); // if not en-US already string[] dates = {"20000203", "19660112", "30300103", "20120316"}; DateTime dt; foreach(string date in dates) { bool isValid = ValidateDate(date, out dt); if(isValid) { Console.WriteLine("'{0}' is valid, translates to {1}", date, dt.ToShortDateString()); } else { Console.WriteLine("'{0}' is invalid", date); } } Console.ReadKey(); } static bool ValidateDate(string date, out DateTime dt) { bool isValid = DateTime.TryParseExact(date, "yyyyMMdd", null, 0, out dt); if(!isValid) return false; DateTime min = new DateTime(1967, 1, 1); DateTime max = new DateTime(3000, 1, 1); if (dt max) return false; return true; } } The output should be: '20000203' is valid, translates to 2/3/2000 '19660112' is invalid '30300103' is invalid '20120316' is valid, translates to 3/16/2012

Jignesh Trivedi · Answer

Hi, you can also try... Just small change in Regex in above code. Regex r = new Regex (@"^((19|20|21|22|23|24|25|26|27|28|29|30)\d\d)(0[1-9]|1[012])(0[1-9]|[12][0-9]|3[01])(\:\d*)$ "); string date1 = "19671201:121212"; string date2 = "30000101:121213"; bool validate1 = r.IsMatch(date1); bool validate2 = r.IsMatch(date2); if (validate1 == false) { throw new Exception("start date is invalid"); } if (validate2 == false) { throw new Exception("End date is invalid"); } if (Convert.ToInt32(date1.Split(':')[0]) > Convert.ToInt32(date2.Split(':')[0])) { throw new Exception("Invalid start date or end date"); } hope this help.

David Smith · Answer

instead of this format I just need to verify if YYYYMMDD is valid instead of :hhmmss

David Smith · Answer

does the DateTime . TryParseExact supports this format, 'YYYYMMDD:hhmmss'? all of the values in the database are in that format. if so can you give me an example supporting that format 'YYYYMMDD:hhmmss'

Gohil Jayendrasinh · Answer

Hi You can also use DateTime.TryParse() Like 1) DateTime dt ; bool isValid = DateTime . TryParseExact ( "08/30/2009" , "MM/dd/yyyy" , CultureInfo . InvariantCulture , DateTimeStyles . None , out dt ); 2) string [] dateStrings = { "05/01/2009 14:57:32.8" , "2009-05-01 14:57:32.8" , "2009-05-01T14:57:32.8375298-04:00" , "5/01/2008 14:57:32.80 -07:00" , "1 May 2008 2:57:32.8 PM" , "16-05-2009 1:00:32 PM" , "Fri, 15 May 2009 20:10:57 GMT" }; DateTime dateValue; Console.WriteLine( "Attempting to parse strings using {0} culture." , CultureInfo.CurrentCulture.Name); foreach ( string dateString in dateStrings) { if (DateTime.TryParse(dateString, out dateValue)) Console.WriteLine( " Converted '{0}' to {1} ({2})." , dateString, dateValue, dateValue.Kind); else Console.WriteLine( " Unable to parse '{0}'." , dateString); } If it's helpful for you then please check Accepted Asnwers Thanks

Jignesh Trivedi · Answer

hi, try.. Regex r = new Regex(@"^((19|20|21|22|23|24|25|26|27|28|29|30)\d\d)(0[1-9]|1[012])(0[1-9]|[12][0-9]|3[01])$"); string date1 = "19671201"; string date2 = "30000101"; bool validate1 = r.IsMatch(date1); bool validate2 = r.IsMatch(date2); if (validate1 == false) { throw new Exception("start date is invalid"); } if (validate2 == false) { throw new Exception("End date is invalid"); } if (Convert.ToInt32(date1) > Convert.ToInt32(date2)) { throw new Exception("Invalid start date or end date"); } hope this help.

Regex DateTIme validation

Answers (6)