
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 10, 2022 03:14 PM
I have a table which has a Payout Month Column, which is a formula:
DATETIME_FORMAT({Check-in date}, 'MMMM')
How can I add the month number in front of the Month word (ie: 1 Jan)?
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 10, 2022 04:10 PM
I think you want…
MONTH({Check-in date}) & ’ ’ & DATETIME_FORMAT({Check-in date}, ‘MMMM’)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 10, 2022 04:05 PM
Hi @Lost-Merovingian!
You can add a D or DD in the formula, like this
DATETIME_FORMAT({Check-in date}, 'D MMMM')
Additionally, if you want the month as a three-letter abbreviation you use just ‘YYY’ for that.
DATETIME_FORMAT({Check-in date}, 'D MMM')
You can find the supported format specifiers for DATETIME_FORMAT here:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 10, 2022 04:09 PM
isn’t the D for Day?
I wanted the Number of the month … like … if it was December … it would show as ‘12 Dec’.
It’s basically, so it’ll show up in order in the interface screen.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 10, 2022 04:10 PM
I think you want…
MONTH({Check-in date}) & ’ ’ & DATETIME_FORMAT({Check-in date}, ‘MMMM’)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 10, 2022 04:15 PM
Fantastic! Thanks so much!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 10, 2022 04:18 PM
My mistake, you are absolutely correct. I read too fast.
I’m glad you got a correct answer above.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 10, 2022 04:59 PM
lol … I do that all the time. Thanks for your quick reply, though.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 10, 2022 05:39 PM
No problem. Btw…
You already have an answer, but thought I’d mention it. You can use the method I mentioned, but instead of D or DD you put M which outputs month number.
Same result, just slightly cleaner.
DATETIME_FORMAT({Check-in date}, 'M MMMM')
