top-image

Tag archives for date

Documentum : BUG in DQL Date Functions When Together Use Of DATEFLOOR, DATEDIFF, DATETOSTRING and DATEADD
Hello, Just a post concerning the BUG of use of DATEFLOOR, DATEDIFF, DATETOSTRING and DATEADD together. To illustrate this problem, for example, we would like to list the documents (r_object_id) modified during the last year: ==> Error occured during query execution :error: "A Parser Error (syntax error) has occurred in the vicinity of: SELECT r_object_id FROM dm_document WHERE r_modify_date >= "   ==> Error occured ...more»
Documentum : Locale, Date Storage, Update of Last Modification Date / Last Modifier (r_normal_tz, r_tz_aware, r_modify_date)
Hi, Just a post concerning the locale, date storing and updating of r_modify_date/r_modifier fields in Documentum, indeed, these fields are overridden automatically during the document's saving. Thus, it's necessary to store and set the previous values of these fields. An other solution could be the creation of a custom attribute 'processing_date' corresponding to the date of action/request on objects. Locale / ...more»
bottom-img
Copyright ® 2012 Huseyin Ozveren. No reproduction, even partial, can be used from this site and all its contents including text, documents, images, etc.. without the express permission of the author.