SI_UPDATE_TS Property

Applies To   See Also  

Indicates the last time the object was modified. Indexed. Read-Only.

Type

Date/Time

Syntax

SELECT

    SI_UPDATE_TS

FROM

    CI_INFOOBJECTS

WHERE

    SI_ID=ObjectID

The syntax has these parts:

Part Type Description

ObjectID

Long

A number that identifies the object you want to retrieve.

Used to access the property from a query result:

QueryResult.Item(Index).Properties.Item("SI_UPDATE_TS")

Remarks

This is a time stamp property which stores the last time the object was modified. An object is modified when any one of its properties change. Note that although the date is returned in the format MM/DD/YYYY HH:MM:SS AM/PM, the format of the date in the query string must be yyyy.mm.dd.hh.mm.ss, where you can omit anything starting from the right, and the separator can be any separator character. The time part must be in local time and it must use the 24 hour clock. For more information, see Date/Time.



Crystal Decisions, Inc.
http://www.crystaldecisions.com
Support services:
http://support.crystaldecisions.com