How to assign a default value "current date/time" to a date field???

5000
4
06-09-2016 10:44 AM
Highlighted
New Contributor III


Hi All,

I'm trying to assign a default value "current date/time" to a date field via "Assign Default to Field" tool in  ArcToolbox. I have tried NOW(), getdate(), today() in the "Default Value"  but they didn't work. What should I put there?

thanks so much!!!

Wilson

Untitled.png

Reply
0 Kudos
4 Replies
Highlighted
Regular Contributor III

As per the below Article, this may be not possible:

How To: Specify the current date as the default value for a Date field when creating new features in...

However, just to confirm, which version of ArcGIS Desktop and what kind of geodatabase (File gdb, Personal gdb, Enterprise gdb) are you using?

Reply
0 Kudos
Highlighted
New Contributor III

Hi Asrujit,

we are using ArcGIS Desktop 10.1 and Enterprise GDB/SDE 10.1 (oracle)

thanks,

Wilson

Reply
0 Kudos
Highlighted
Regular Contributor III

Have you thought about using the Editor Tracking functionality that was introduced at 10.1...

Enable Editor Tracking—Help | ArcGIS for Desktop

Enabling and managing editor tracking—Help | ArcGIS for Desktop 

(The above links are for 10.3.x, but the logic remains the same)

Highlighted
New Contributor III

Yes, I am also using "editor tracker" to  track record created and updated info as well. But we need a third date field/info to track something else...

Reply
0 Kudos