Extract Month and Year from a Date String

Help Center Get Answers
1

This is probably super easy and I’m just not seeing it. I have an Event Date and I want to pull out the numerical Month (e.g., 06 for June) and the 4 digit Year so that I can Group records. If it’s part of the knowledgebase or documentation, pointing me in the right direction is help enough. Thank you all,

2

Nevermind - I found the functions. Thanks anyway!

3

I’ve only just seen your post, I’m glad you found the answer. :+1:

Just in case anyone else reads this post and wonders what the answer is, I thought I’d reference the knowledge base article.

You simply use the “formatDate” function in a Text Formula field and then use the appropriate Output Format. There are lots to choose from to allow you to extract year month and days. :rocket:

1 Like