topic Re: Text field --> Date field in ArcGIS Pro Questions

Text field --> Date field

Laura — Thu, 17 Aug 2023 19:18:21 GMT

I am trying to populate a new layer based off of some old data I found. However, this one text field that is housing Date info is a little odd. There are spaces between everything and there is a "12:" after almost every entry. How do I get this into my new date field?

Laura_0-1692299867935.png

Re: Text field --> Date field

Robert_LeClair — Thu, 17 Aug 2023 19:56:40 GMT

So the first thing to do is replace the 12: in your text field to be a valid (generic) time. To do this, I calculated the existing text field using the Replace function:

Replace($feature.date_text, '12:', '12:00:00') - see first image below.

Then in the date/time field, I did another field calculation using the following function:

$feature.date_text - see second image below.

The date/time field now has a valid date/time value that shows 12 noon.

FieldCalc1.JPGFieldCalc2.JPG

Re: Text field --> Date field

Laura — Thu, 17 Aug 2023 20:14:28 GMT

Hm, didn't quite work for me. Not sure where all those 000s are coming from

Laura_0-1692303246177.png

Re: Text field --> Date field

Robert_LeClair — Thu, 17 Aug 2023 20:20:45 GMT

Hmmmm...that's strange. Can you share the data with me so I may do some testing? My email is rleclair at esri dot com

Re: Text field --> Date field

Laura — Thu, 17 Aug 2023 20:23:39 GMT

Sure