Hi
I have a beginner question to convert a string to datetime format. My input format in field [Starttime] is:
30 Jan 2017 07:55:44
How can I convert it with the Formula tool (I think) to a date time field ?
Many thanks in advance for your answer
Steffen
Solved! Go to Solution.
It should work with this....
DateTimeParse([Starttime], "%d %b %Y %H:%M:%S")
If you check out the Help for Date/Time functions, you will see a section on Specifiers...that's what you put in your "template" to parse what you have into a true DateTime data type.
Thx it works perfect
Steffen
@MarqueeCrew, that's a rarity...guess I'm mark today on my calendar! ;-)
What's going to be great is in 11.0 we will be able to build out the "custom template" within the DateTime tool...which should be much easier!