field calcs with substring

JustinWolff

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)<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

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.

bixb0012

The default expression type for Field Calculator in Pro is Python with the option to use Arcade.  You appear to trying to use SQL, which isn't a supported expression type.

Trying this using the Python expression type:

<SPAN class="string token">"{}/{}/{}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>!LastUpdateDate!<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> !LastUpdateDate!<SPAN class="punctuation token">[</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> !LastUpdateDate!<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>