nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

VincentLaunstorfer

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

Encontre mais publicações marcadas com

Accepted answers

VincentLaunstorfer

Fount it! The statment is:

return None

with no single quotes!

All comments

DanPatterson_Retired

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

VincentLaunstorfer

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

VincentLaunstorfer

Fount it! The statment is:

return None

with no single quotes!

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.