What's new in Thereforeā¢ 2017 Update 2 |
Scroll |
Until Thereforeā¢ Update 2, DateTime properties were inconsistent regarding the time zone they used. Some properties were using UTC, some local time. With Thereforeā¢ 2017 Update 2 all DateTime properties have been changed to use UTC, including query conditions.
Query conditions can only make use of the time values in conditions made on meta data fields from the TheIntQueryField enumeration like LastModified and CreatedOn.
This is a list of all DateTime properties that were changed from local time to UTC:
TheDocumentProperties.CheckedOutOn
TheDocumentProperties.CreatedOn
TheDocumentProperties.LastModified
TheRecycleBinQuery.DeletedOnFrom
TheRecycleBinQuery.DeletedOnTo
TheWFInstance.ProcessStartDate
TheWFInstanceInfo.ProcessDueDate
TheWFInstanceInfo.ProcessStartDate
TheWFInstanceInfo.TaskStartDate
All other DateTime values have not been changed because they either already used UTC in previous versions or the time value is ignored.
TheDocumentProperties.CreatedByDisplayName
TheDocumentProperties.CreatedByUserNo
TheDocumentProperties.CheckedOutByDisplayName
TheDocumentProperties.CheckedOutByUserNo
TheDocumentProperties.ModifiedByDisplayName
TheDocumentProperties.ModifiedByUserNo