Month Only From Date

I have a DateTime field. The current format is 2015-02-02 00:00:00. I simply want to pull from this date the month in a string format. The answer should be 2. I'm sure it's easy, I've looked but not able to find an answer.

Date Time

Preparation

Accepted answers

Ned

Use a formula tool. You could either do:

DateTimeFormat([Field1],"%m")

or

Substring([Field1],5,2)

Either way works the same. It all depends if you want to think of it as a date or as a string.

All comments

Ned

Use a formula tool. You could either do:

DateTimeFormat([Field1],"%m")

or

Substring([Field1],5,2)

Either way works the same. It all depends if you want to think of it as a date or as a string.