topic Re: How to assign a default value "current date/time" to a date field??? in Geodatabase Questions

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

WilsonLee — Thu, 09 Jun 2016 17:44:17 GMT

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

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

AsrujitSengupta — Thu, 09 Jun 2016 18:43:01 GMT

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 ArcMap

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

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

WilsonLee — Thu, 09 Jun 2016 18:48:08 GMT

Hi Asrujit,

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

thanks,

Wilson

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

AsrujitSengupta — Thu, 09 Jun 2016 18:58:08 GMT

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)

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

WilsonLee — Thu, 09 Jun 2016 19:17:43 GMT

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