I have a question about using the Formula Tool

[dhxodud96]

As shown in the screenshot below, I want to combine Month(E) and Day(E) to create a new Column with Date Type, but I don't know how. Right now Month and Day column is string type.

Ex) 2013-01-05, 2013-01-07 ...

It looks like I have to use Formula Tool.

 

I've spent an hour and haven't found the answer.

Any help would be greatly appreciated. Thanks

[Qiu · Accepted solution]

@dhxodud96 
We will construct a string that contains your date field then use the DateTimeparse or DateTime tool to parse it to Date Format.

[dhxodud96]

Thanks a lot!

Have a good day :)