Hi, I am trying to count the number of months from the Start Date till today. The actual day of the 'Start Date' doesn't matter. For example, if 'Start Date' is 9/20/23 and today is 12/11/23, I want to count the number of months that have passed: S...
Hi Airtable Community -I have table A which has a column that stores links to records in table B. When I am in an expanded view of a record in table A and I click on the linked entry to open the linked record in table B, what determines what view is...
Happy New Year, Airtable Community!Each year I document my Airtable environment. Does anyone know if there is an easy way to obtain a list of synced tables (with source and destination) that would save me the effort of going into each base to look fo...
Hi all - I know dates and timezones are complex, and I’ve tried to do my homework but I’m really stumped. My end goal is to identify records created yesterday and send off a notification. To start, I’m attempting to calculate how many days are betwe...
Hi Airtable Community,
I have created new fields and an automation to allow me to automatically send out an email and Teams message 2 days prior to an observed holiday in our Company Calendar table. I have successfully figured out the date when the a...
Thank you, the solution using DATETIME_DIFF and DATETIME_PARSE works - though I had to add "+1" to the end of the formula. I did some testing crossing year boundaries and it works. This is a really helpful formula, I appreciate your help!
Hi again, I do appreciate your help, but this version only seems to work within the same year. As soon as it crosses a year boundary it's not right. If Start Date = '9/20/23', and Today is '1/10/24', the result is -7 rather than 5 (Sept, Oct, Nov, ...
Hi @Sho , I tried this and it's giving me an answer of 3 instead of 4. I think it's taking into account the days, and not just looking at months. I'm assuming someone worked even 1 day each month between the Start and today, so then I need to count...
Thanks for that information, but it does raise a question for me. Can't each collaborator change the order of their views - maybe some have Favorites, maybe some don't. As an Admin/Developer - can I control the order in which they appear?Thanks aga...
