Text field --> Date field

[Laura]

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?

[Robert_LeClair]

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.

[Laura]

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

[Robert_LeClair]

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

[Laura]

Sure