DateCreated, LastUpdated Properties

    Example    Applies To   

• DateCreated returns the date and time that an object was created, or the date and time a base table was created if the object is a table-type Recordset object (Microsoft Jet workspaces only).
  
  
• LastUpdated returns the date and time of the most recent change made to an object, or to a base table if the object is a table-type Recordset object (Microsoft Jet workspaces only).

Return Values

The return value is a Variant (Date/Time subtype).

Remarks

For table-type Recordset objects, the date and time settings are derived from the computer on which the base table was created or last updated. For other objects, DateCreated and LastUpdated return the date and time that the object was created or last updated. In a multiuser environment, users should get these settings directly from the file server to avoid discrepancies in the DateCreated and LastUpdated property settings.