Problems making a DateTime

[Timothy_Leber]

I am trying to combine a date and a time to make a DateTime.  Everything I do ends up with the time being set to all zeros.

I have the time as a string in the data, but it is not in the proper format.  So instead of 02:20 I have '220'.  I have it fixed to the correct time format.

My Google skills are letting me down on this one.  I am attaching a sample file of my data.

Thanks

[michelle_mathews · Accepted solution]

Hi @Timothy_Leber , you can use the DateTime tool to convert your time columns to the proper time format - see screenshot attached. Then you can use a formula to join that with your date field ([date]+" " +[time]) and mark it as a datetime type. 

[Timothy_Leber]

I already had the time thing figured out, but figured I was missing something simple on the DateTime conversion.