Jsummers at 14:38, 27 July 2018

2018-07-27T14:38:00Z

Jsummers: Created page with "{{FormatInfo |formattype=electronic |subcat=Elements of File Formats }} '''OLE Automation Date''' is one of the date/time formats used with Microsoft's ''OLE Automation'' API...."

2018-07-27T14:33:51Z

Created page with "{{FormatInfo |formattype=electronic |subcat=Elements of File Formats }} '''OLE Automation Date''' is one of the date/time formats used with Microsoft's ''OLE Automation'' API...."

New page

{{FormatInfo
|formattype=electronic
|subcat=Elements of File Formats
}}
'''OLE Automation Date''' is one of the date/time formats used with Microsoft's ''OLE Automation'' API. It may be used in [[OLE Property Set]]s, for example.

It is also be known as '''OLEAUT date''', '''VARIANT DATE''', '''variant time''', '''VT_DATE''', etc.

== Format details ==
It is in the form of an 8-byte floating point number.

Positive values correspond to the number of days (including fractions of a day) since "midnight 1899-12-30". Apparently this means the midnight at the ''beginning'' of 1899-12-30, i.e. 48 hours before the beginning of the year 1900.

Negative values are interpreted in a more complex way.

The valid range is usually considered to be the years 100 through 9999.

Times are usually treated as being in local time.

== Links ==
* [https://blogs.msdn.microsoft.com/ericlippert/2003/09/16/erics-complete-guide-to-vt_date/ Eric’s Complete Guide To VT_DATE]
* [https://msdn.microsoft.com/en-us/library/cc237549.aspx [MS-OAUT]], §2.2.25
* [[Wikipedia: OLE Automation]]

[[Category:Date and time formats]]
[[Category:Microsoft]]

@@ Line 3: / Line 3: @@
 |subcat=Elements of File Formats
 }}
-'''OLE Automation Date''' is one of the date/time formats used with Microsoft's ''OLE Automation'' API. It may be used in [[OLE Property Set]]s, for example.
+'''OLE Automation Date''' is one of the date/time formats used with Microsoft's ''OLE Automation'' API. It is used in some [[OLE Property Set]]s, for example.
-It is also be known as '''OLEAUT date''', '''VARIANT DATE''', '''variant time''', '''VT_DATE''', etc.
+It is also known as '''OLEAUT date''', '''VARIANT DATE''', '''variant time''', '''VT_DATE''', etc.
 == Format details ==

OLE Automation Date - Revision history

Jsummers at 14:38, 27 July 2018

Jsummers: Created page with "{{FormatInfo |formattype=electronic |subcat=Elements of File Formats }} '''OLE Automation Date''' is one of the date/time formats used with Microsoft's ''OLE Automation'' API...."