- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 01, 2020 04:11 AM
Hey,
Is there a formula that pics the name of the month by date. We have built a system where we manage our project invoicing. We send our customers an invoice on a monthly basis based on the work completed, but we try to forecast the billing months by recording the assumed billing month for the project part. So, Airtable should understand that the (billing) month is a date field (billing predictability), but the option value should be the name of the month
Thanks
Mikko
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 01, 2020 06:17 AM
To convert a date to a month name, use the DATETIME_FORMAT()
function with the MMMM
format specifier.
DATETIME_FORMAT({date}, 'MMMM')
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 11, 2021 01:56 AM
Hi @kuovonne, thanks for your reply :slightly_smiling_face:
Do you know how I could add the year, after your fomula with the month ?
So I could convert : 2021-05-11
To May 2021 for exemple
Thanks ! :slightly_smiling_face:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 11, 2021 01:19 PM
You can include the format specifier for the year.
DATETIME_FORMAT({date}, 'MMMM YYYY')
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 30, 2021 11:31 PM
Sorry for the late reply, I missed it ! Thanks for your reply ! :slightly_smiling_face:
By chance, maybe you could help me with another little issue :
When I use this formula and group my row by date (with the month and year), Airtable sort the date in alphabetical order, and not Chronologic order.
Do you know if there is a way to sort by chronologic order, to have :
January 2019
February 2019
…
January 2020
Thanks !
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 11, 2022 07:15 PM
Im interested to know also
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 06, 2022 05:30 AM
Hi,
I ran into the same issue, so I concatened the month number with the month:
DATETIME_FORMAT({Date}, ‘MM MMMM’)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 16, 2022 12:08 AM
Thank you so much for answering this question! Just wondering what I would add to this formula to leave it blank if there’s no date selected, rather than returning an #ERROR? Thank you
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 16, 2022 06:14 AM
IF(
{date},
DATETIME_FORMAT({date}, 'MMMM YYYY')
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 19, 2022 04:14 PM
Thank you! Really appreciate your quick help :slightly_smiling_face: