Does anyone have a more elegant method to convert an Excel OLE Automation Date (e.g. 43983.XXX) into a DateTime in Dundas? The data source is a Microsoft Form Excel backend, which gets read in as a string. I then convert it to a double and do the script below:
DateTime datezero = new DateTime(1899,12,30);
DateTime ConvertedDate = datezero.AddDays($OADate$);
There is a method in .NET to do this (FromOADate and ToOADate) but they are not available in the Dundas library. All of the date conversion documentation in Dundas is if the date was already in a string and could be translated using a mm/dd/yyyy format variation.