topic How to add in a set date to attribute table in ArcGIS Pro Questions

How to add in a set date to attribute table

AndrewEastop — Thu, 14 Oct 2021 11:26:42 GMT

Hello,

Is there a way I can change the date in the DateCaptur field of my attribute table to say 06/07/2020 ? I had tried to do this as a calculate field expression but somehow came out with a date fro 1970!

Any help would be very much appreciated

Re: How to add in a set date to attribute table

JayantaPoddar — Thu, 14 Oct 2021 11:58:16 GMT

Where is the data stored? (Shapefile, File GDB, Enterprise GDB, etc.)

What expression did you use?

Have you tried (Arcade expression)

Date(2020,07,06)

Re: How to add in a set date to attribute table

AndrewEastop — Thu, 14 Oct 2021 12:59:26 GMT

The data is sorted in a filegdb.

Have tried to do the same expression you have said here and that is what gives me the random date. Got 09/02/1912 this time lol

Re: How to add in a set date to attribute table

JayantaPoddar — Thu, 14 Oct 2021 13:38:24 GMT

What about the following expression in Arcade? Put the date in double quotes.

"2020-07-06"

"06/07/2020"

Re: How to add in a set date to attribute table

Robert_LeClair — Thu, 14 Oct 2021 15:20:54 GMT

So I used Arcade for the Date calculation using Date(2020,5,7,0) on a Date/Time field and as seen in the attached file it calculated the field to be 6/7/2020 at 6 AM in this case. The key is that the month field starts January as a zero and counts to 11 for December.

Re: How to add in a set date to attribute table

AndrewEastop — Thu, 14 Oct 2021 15:24:30 GMT

The double quotation did the trick... i hate code!

thanks very much

Re: How to add in a set date to attribute table

AndrewEastop — Thu, 14 Oct 2021 15:25:54 GMT

thank you for the reply Robert