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

7605
4
06-09-2016 10:44 AM
WilsonLee
Occasional Contributor


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

0 Kudos
4 Replies
AsrujitSengupta
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?

0 Kudos
WilsonLee
Occasional Contributor

Hi Asrujit,

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

thanks,

Wilson

0 Kudos
AsrujitSengupta
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)

WilsonLee
Occasional Contributor

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...