Convert CSV String 30 Jan 2017 07:55:44 to Date/Time

chvizda

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

Date Time

Preparation

Accepted answers

RodL

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.

All comments

RodL

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.

MarqueeCrew

Excellent response @RodL. I tested it and it worked!

You taught me something new today

Cheers,

Mark

chvizda

Thx it works perfect

Steffen

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335