Skip to main content

Converting date 1/4/19 to January and so on

  • March 22, 2019
  • 2 replies
  • 31 views

Forum|alt.badge.img+5
  • Participating Frequently

Building a budget and I’ve searched for 2 days on this formula and now realize, its time for help.
I have my paycheck weeks listed but I want to group by month - I’ve added a new table labeled Month to convert (using a formula) the dates to the corresponding month. For instance…
1/4/19 would be January
2/15/19 would be February
4/5/19 April and so forth.

Thank you in advance for your help.

2 replies

Kamille_Parks11
Forum|alt.badge.img+27

Make a Formula field using this formula: DATETIME_FORMAT({Date field},'MMMM')


Forum|alt.badge.img+5
  • Author
  • Participating Frequently
  • March 22, 2019

Genius Kamille! Maybe I just need to visualize the formula!
Thank you.