Skip to main content

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.

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


Genius Kamille! Maybe I just need to visualize the formula!

Thank you.


Reply