Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What kind of date format is "401769" and how can I get this formatted like a real date?

What kind of date format is this and how can I get this formatted like a real date?

Expiredate="401769" 

Effectivedate="0" ModifiedWhen="39316.262472303242" CreatedWhen="38476.390116666669"

This is from Microsoft Content Management Server (MCMS) 2002 .sdo file (XML file exporting data)

like image 305
jpkeisala Avatar asked Feb 04 '26 08:02

jpkeisala


1 Answers

DateTime.FromOADate(39316.262472303242) should get you the DateTime //gives 22/08/2007

like image 113
V4Vendetta Avatar answered Feb 05 '26 21:02

V4Vendetta



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!