Microsoft Office Auto Date Fields
There are dynamic fields for Microsoft Office that show date, time or other information that is retrieved from document or system properties. Administrators can configure for each project, if and how fields are replaced with content for conversion.
For ultimately consistent results, configure conversion to use field codes instead of field content.
Auto date fields
-
There are different types of auto date fields:
Those that reflect the date of a special action, likeCreateDate,PrintDate,SaveDate. - Those that reflect the
current date and that are updated whenever you open a document. The field code
of these fields starts with
TIMEorDATEin Microsoft Word. In Excel, the field code isToday()orNow(). In PowerPoint, these are the date or time fields for which the option Update automatically is selected.
Auto date fields that reflect the date of a special action use the time zone and the time of the native document during native conversion.
Auto date fields that reflect the current date are treated differently depending on document type:
- Excel and PowerPoint
- Auto date fields that reflect the current date use the local time zone and the local time of the conversion server.
- Word
- By default, the auto date field starting with
TIMEorDatefield and that reflects the current time, is replaced with the date of the last modification before the document was loaded into the CORE system. This date is extracted from the Modified field in the file properties of the Microsoft Word document during native conversion. The date is shown in the local time zone of the conversion server. - Administrators can configure the exact behavior for auto date or time fields in Word documents.
Auto dates in same Microsoft Word document might use different time zones
The date and time value for auto date fields that reflect the current
time (i.e., field codes starting with
TIME or
DATE) is calculated using the conversion server time
zone. Fixed date fields (like
CreateDate,
PrintDate,
SaveDate) are not re-calculated. They therefore use
the time zone of the native document.
At reconversion, Excel and PowerPoint documents with auto date fields for the current date are not converted consistently.
As auto date fields that show the current date use the local time of the conversion server, the converted document that you create on one day is not the same as the one you create on another day.
As a workaround, configure that the field code is used instead of the date value.