I have a question about using the Formula Tool

Question

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 Answer

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