1,126
edits
Difference between revisions of "Date and Time formats in Content Manager OnDemand"
Jump to navigation
Jump to search
m
Date and Time formats in Content Manager OnDemand (view source)
Revision as of 17:05, 20 January 2018
, 17:05, 20 January 2018Added section on IBM CMOD timestamp conversion in Excel.
m (Changed IBM CMOD v9.5 to IBM CMOD v9.0 to be accurate.) |
m (Added section on IBM CMOD timestamp conversion in Excel.) |
||
| Line 77: | Line 77: | ||
Where the cell 'A1' contains a date in the CMOD internal date format. | Where the cell 'A1' contains a date in the CMOD internal date format. | ||
If you have CMOD internal date format instead, you can use this function instead: | |||
=(A1/86400 + 22568) | |||
This should give you an approximate date/time -- but beware that you will likely need to make accommodations for time zone changes between the server that produced the report, the time zone of the CMOD server where the data was loaded, and your local PC, depending on how you obtained the data. | |||
== IBM CMOD arsdate command online help == | == IBM CMOD arsdate command online help == | ||