Hello.
I need break apart Activity Date/Time into discrete dates and times.
For example I need the following activity date/time: 2016-10-24 06:00:24 broken out into 2 separate fields.
Date: 2016-10-24
Time: 06:00:24
Another option is to use a Formula tool, setting the data type for two new fields to Date and Time respectively, both with the same expression.
For example:
Couple of different options here. I would say the easiest, if you format your DateTime field as a string would be to simply use Text To Columns and split on ' '. The other option, if you are less sure of the incoming format, would be to use the RegEx tool. See attached.
