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!!!
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?
we are using ArcGIS Desktop 10.1 and Enterprise GDB/SDE 10.1 (oracle)
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)
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...