topic Auto Calculate a Date Field in ArcGIS Online Questions

Auto Calculate a Date Field

Anonymous User — Tue, 13 Nov 2018 20:39:42 GMT

I am trying to automatically calculate a date field. What I would like to do is take a permit date and add 180 days to calculate an expiration date. I added a date field for the final calculation. I open the field calculator and write the expression. The expression verifies correctly but when I calculate the field I get errors. I tried several different calculations to see if any of them would work. Below is an example of a calc I did to extract a date. Again, the expression verified correctly but then this error popped up when I calculated the field.

Re: Auto Calculate a Date Field

MikeMinami — Thu, 15 Nov 2018 01:13:32 GMT

From the error message, it appears you're using the extract function. This function, I believe, returns a number. If you are trying to assign this value to a date field, you'll get a field type mismatch of trying to calculate a number into a date field.

If your goal is to simply add 180 days to a date in a field and assign it to another field, you can form an expression like this:

[PermitDate] + 180

Under normal circumstances, this would yield a new date 180 days into the future. HOWEVER, THERE IS A BUG in AGOL with date addition, where it doesn't work. Subtraction, however works. So try this expression

[PermitDate] - -180

Where you subtract negative 180.

Mike

Re: Auto Calculate a Date Field

Anonymous User — Thu, 15 Nov 2018 20:13:46 GMT

Thank you Mike. Your suggestion of adding a negative did work in Desktop, but it did not work in ArcGIS online. This still solves my problem with the calculation and works for me.

Veronica

Re: Auto Calculate a Date Field

GISAdministrator16 — Thu, 27 Jun 2019 02:52:08 GMT

Regarding the bug in AGOL when calculating a date field, I found that when I turned off the sync setting, a calc operation worked properly. When sync was on, the calc would fail.

--Jeff