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; } } }

Create DateTime from separate Date and Time fields

ToyotaT18

I have a CSV dataset which has separate date and time fields. When imported to a feature class, the date field is of type 'date' and the time field is 'text'. I want to keep these separate, but add a new field to store a DateTime, ie a combination of the date and time. Can someone let me know how to enter this in the field calculator? I've tried using strptime() but it doesn't seem to let me cast the date as a string. Thanks.

Find more posts tagged with

Content Management

Accepted answers

danretired

datetime combine?

There are python examples

Easiest way to combine date and time strings to single datetime object using Python - Stack Overflow

Since you have already have the data in a field, it would be a matter of converting the time appropriately then combining. The contents of your text time field would determine what the final formula would look like

All comments

ToyotaT18

Thanks Dan, I got it to work.

Expression: convertdatetime(!time_from!,!date_from!)

Code Block:

def convertdatetime(sTime, dDate):
tTime = datetime.strptime(sTime, '%H:%M').time()
dt = datetime.combine(dDate, tTime)
return dt

I was hoping to wrap it up into a single statement but it doesn't work for some reason, something like:

datetime.combine(!date_from!, datetime.strptime(!time_from!, '%H:%M').time())

But that's ok, the solution works so I'm happy with that.

MervynLotter

The easiest approach may be to first open up the CSV in Excel and then combine the two fields into one field using a formula such as "=TEXT(C2,"yyyy/m/dd ")&TEXT(D2,"hh:mm:ss")". But then once you add the CSV file to Pro, your new field will be recognised as a text field and not a date field, so then you need to run the Convert Time Field GP tool to convert it to a date field.

danretired

datetime combine?

There are python examples

Easiest way to combine date and time strings to single datetime object using Python - Stack Overflow

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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