in reply to Re: Win32::OLE Excel how to get milliseonds from date variant?
in thread Win32::OLE Excel how to get milliseonds from date variant?

Right, you can to that in Excel. It changes how the data is displayed in the spreadsheet but the value is still stored as a variant. When you access via Win32::OLE that's what you get, and you need to use that Date() method to turn it into a usable string. So I am trying to find out what argument to that method will give YYYY-MM-DD HH:MM:SS.000 format.
  • Comment on Re^2: Win32::OLE Excel how to get milliseonds from date variant?