[GIS] Geodatabase add current date and time to attribute

arcgis-10.0arcgis-desktopdatetime

Is it possible in Arcmap 10.0 to create a geodatabase feature class that has a date field which auto populates with the current date and time, every time a new feature is created? Is this possible without programming? Have checked ESRI help but nothing. The feature class is not in ArcSDE so it is not versioned.

Best Answer

The code attached in here might help you: http://forums.arcgis.com/threads/9374-Timestamper-for-ARCGIS-10

Related Solutions

[GIS] Select by Attributes Where Clause how to get current date

ESRI documentation says it follows SQL 92.

SQL 92 says subtraction of dates returns number of days.

This works with a file geodatabase to select rows older than 65 years:

(current_date - "DateField") > 365.0 * 65.0

[GIS] Creating ArcSDE feature class in MS SQL Server

You need to register your view and spatial column in SDE.

There are two good help topics regarding this question:

Example: Creating a spatial view in SQL Server using SQL and registering it
Example: Creating a spatial view in SQL Server using the sdetable command

Best Answer

Related Solutions

[GIS] Select by Attributes Where Clause how to get current date

[GIS] Creating ArcSDE feature class in MS SQL Server

Related Question