topic Re: ArcGIS Pro 2.1 - How to calculate Null values in a date field in shapefile? in Python Questions

ArcGIS Pro 2.1 - How to calculate Null values in a date field in shapefile?

VincentLaunstorfer — Thu, 17 May 2018 12:34:01 GMT

Hi,

In a model, after joining a shapefile to a text file, I am trying to calculate a newly created Date format field in the shapefile. But, whenever I have an empty date in the text file, the if else statment catches it and tries to fill a Null value in the Date field. But it crashes and not not work!

I tried:

return ''

return 'None'

return 'Null'

return '0'

But none worked! Any guess for the proper syntax? Thanks

Re: ArcGIS Pro 2.1 - How to calculate Null values in a date field in shapefile?

DanPatterson_Retired — Thu, 17 May 2018 22:46:01 GMT

you have a code block but no field calculator expression

Addendum Shapefiles don't support None, you will have to check for the empty string "" or ''

Re: ArcGIS Pro 2.1 - How to calculate Null values in a date field in shapefile?

VincentLaunstorfer — Fri, 18 May 2018 13:10:45 GMT

Tried "" or '' but still no luck! Tested it on shapefile and FGDB feature class as well.

As for the field calculator expression, it looks empty but actually it is not. It always does not show for no reason.

The problem comes from the None or Null format in the date field because if I set any date instead, it does work. Also, it works in former ArcToolbox. Is it related to Python 3 ? There must be a solution...

Re: ArcGIS Pro 2.1 - How to calculate Null values in a date field in shapefile?

VincentLaunstorfer — Fri, 18 May 2018 13:42:17 GMT

Fount it! The statment is:

return None

with no single quotes!