- 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
May 19, 2022 04:32 PM
Ok, so it worked for one field that had the simple formula as above, but how would I add it to this formula so it doesn’t return ERROR when the Date/Time field is empty? Thank you! :slightly_smiling_face:
{Event Name} & " - " & DATETIME_FORMAT(SET_TIMEZONE({Date & Time}, ‘Australia/Brisbane’), “DD/MM/YY”)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 19, 2022 09:20 PM
It depends on what you want to have instead of the date. Here is one way.
CONCATENATE(
{Event Name},
" - ",
IF(
{Date & Time},
DATETIME_FORMAT(SET_TIMEZONE({Date & Time}, 'Australia/Brisbane'), "DD/MM/YY"),
"no date"
)
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 20, 2022 08:48 PM
Thank you! That worked perfectly! I just changed “no date” to “Date TBA.”
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 20, 2022 08:59 PM
Also @kuovonne, I posted a question on a feed that was a couple of years old that you had also been helping on, not sure if you’ve seen it, but if you have a moment I’d really appreciate your input since you’ve been so helpful and your explanations are really easy to follow.
Thank you! :slightly_smiling_face:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 09, 2022 09:48 AM
I actually group first by Month number, and then by month name, which worked great for me :).
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 13, 2023 12:38 PM
I'm struggling with a similar issue. I have the below formula. everything works, except, air table will not interpret the outcome as a date and will not sort logically (by month) but by alphabet.
DATETIME_FORMAT(IF(AND(
MONTH({Due Date}) < MONTH(TODAY()),
{Payed?} = FALSE()),
DATETIME_FORMAT(TODAY(),'MMMM YYYY'),
DATETIME_FORMAT({Due Date},'MMMM YYYY')
),'MMMM YYYY'
)
hope someone can help with this!
thx in advance
- « Previous
-
- 1
- 2
- Next »