I have a string variable (fileDateString) with the date in this format: 20150404
In my feature class there is a text field with time in twenty-four hour UTC format. There is also 2 leading spaces before the time. E.g. " 1300"
I have added a Date field to my feature class and I would like to calculate a date/time. I also want to be able to subtract 6 hours from the date/time (convert UTC to CST) for the final result.
I thought about first creating a text field with the date and time, then converting that to date but am wondering if there is an easier way?
expression = "\"" + str(fileDateString) + "\"" + "!DateUTC!"