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.