Parsing IDO Date fields to DateTime object?

Legacy Contributor

This is one of those annoyances begging for a proper solution to avoid having to repeat the same workaround over and over again...

Is anyone aware of a Mongoose Framework method or otherwise, that will take the date format returned from an IDO LoadCollection request (20201118 00:00:00) and convert it into either a SQL format (2020-11-18 00:00:00) that DateTime.Parse can parse, or directly into a DateTime object? Casting (DateTime) and GetValue<DateTime> also fail because of the unrecognized date format.

The current workaround that I and others that I know do is to use a series of string.Substring() methods to pull out the date parts and create a DateTime object out of the parts.

Thanks,

Tim

Stephen Cena

I think that you're looking for is DateTime.ParseExact. It lets you specify the format of the string you're passing in:

string iString = "2005-05-05 22:12 PM";
DateTime oDate = DateTime.ParseExact(iString, "yyyy-MM-dd HH:mm tt",null);
MessageBox.Show(oDate.ToString());

So based on your example, the string would be: yyyyMMdd HH:mm:ss

Is that what you were looking for?