Select to view content in your preferred language

Can’t calculate field to <NULL> using None

449
6
Jump to solution
07-25-2024 11:27 AM
Jim_Riedmann
Occasional Contributor

I’m using ArcGIS Pro 3.3.1.  I have an attribute table with a date field.  I want to replace some of the values in the field with <NULL>.  Using the field calculator, with the Expression Type set to Python, I type None in the space for the new field value.  I get Warning 003571 and the value in the table stays the same.  I can’t find any way to get <NULL> into the date field.   I looked at the Fields view and NULL is allowed for that field.

0 Kudos
1 Solution

Accepted Solutions
Eugene_Adkins
Frequent Contributor

Using Field Calculator/Arcade, type "return null" and if the fields are nullable this should work.

View solution in original post

6 Replies
Eugene_Adkins
Frequent Contributor

Using Field Calculator/Arcade, type "return null" and if the fields are nullable this should work.

Jim_Riedmann
Occasional Contributor

That method works, thanks very much.

0 Kudos
KenBuja
MVP Esteemed Contributor

Even though you do get that warning, the date values are calculated to null.

Snag_173811a.png

0 Kudos
Jim_Riedmann
Occasional Contributor

No, they are not calculated to NULL.  They remain unchanged.

0 Kudos
KenBuja
MVP Esteemed Contributor

That's curious, since it worked in my testing. I created a new date field, copied an existing field's dates into the records, then set them to null again. The screen image was the last step in my process.

0 Kudos