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

[WilsonLee]

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

[AsrujitSengupta]

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?

[WilsonLee]

Hi Asrujit,

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

thanks,

Wilson

[AsrujitSengupta]

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]

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