AnsweredAssumed Answered

field calcs with substring

Question asked by jwolff on Oct 13, 2020
Latest reply on Oct 14, 2020 by jwolff

I have a text field with date values in YYYYMMDD format.  I need to get them into the MM/DD/YYYY format in a text field (the target field for the MM/DD/YYYY values is text, not date).  The source field containing the YYYYMMDD values is named 'LastUpdateDate' and the target for the MM/DD/YYYY values is named 'CAMAUpdate'.  I'm attempting to use this:

 

SUBSTRING(!LastUpdateDate!,4,5)+'/'+SUBSTRING(!LastUpdateDate!,6,7)+'/'+SUBSTRING(!LastUpdateDate!,0,3)

 

In Pro 2.6.2 it fails with:

ERROR 000539: Traceback (most recent call last):
File "<expression>", line 1, in <module>
NameError: name 'SUBSTRING' is not defined

 

Source data is a polygon feature class in a file geodatabase.

Outcomes