Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Resolved! Date Span Crossover Formula/Script?

HiIf anyone has any ideas about this I would be very grateful - I can't quite see a way through this one!One of the elements of the system I'm building schedules the use of specific tools. I would like to be automatically notified if a tool is double...

Jon by 6 - Interface Innovator
  • 8 replies
  • 2 kudos

Resolved! Adding formula fields for recurring dates, including SET_TIMEZONE

Hi, I'm sure the answer to this is really simple and I'm just missing it, but could someone please take a look at this formula and let me know why some records would be throwing an ERROR, but others are working? I'm thinking I've got something in the...

Meagan_Caesar by 6 - Interface Innovator
  • 6 replies
  • 0 kudos

Setting Timezone without Time in Date Field

Hello!I'm having issues with Airtable's default GMT timezone. I have a Date field (which I do not want to have time displayed for) as well as a formula field using the DATEADD formula to calculate the next time a task is due, based on frequency. In t...

Screenshot 2023-02-20 at 2.10.04 PM.png Screenshot 2023-02-20 at 2.07.35 PM.png

Resolved! DATETIME_FORMAT returning wrong time - 24hours system

I am struggling to get the DATETIME_FORMAT to return the correct time for me. For example, my Start Date is 10 January 2023 00:00 and in my formula column, I just want it to extract the time of the "Start Date". So I put in this formula: DATETIME_FOR...

MCC by 5 - Automation Enthusiast
  • 2 replies
  • 2 kudos

Calculating Due Dates

Hello!I am creating a list of tasks that need due dates assigned using the following conditions:1. Each task is due one day after the previous task is due (note: dependencies would be nice to have but not necessary)2. The tasks are never due on Frida...

How to check if a date is a weekend or a holiday?

Hi expert guys and gals, I am struggling with what appears to be a straightforward mundane issue, but I have scoured the Community and the internet without any luck. I have workers schedules and sometimes they work Monday to Friday, but sometimes the...

hristovm by 5 - Automation Enthusiast
  • 5 replies
  • 3 kudos

Display if the field has a number

I'm working with some data coming from another group and they use both text and dates in a fields that I need to pull apart and use the dates to estimate further due dates down the line. I'm trying to avoid the big #ERROR! when the field has text and...

fields.jpg Formula.jpg

Calculation for birthday - off by 1 day or not date formatted

I'm trying to create a date formula with the next/upcoming birthdate from a staff profile with Date of Birth. I need this to be formatted as a date so I can use it in a calendar, which has proven to be more difficult than I anticipated. Here are 2 wa...

tgrier by 5 - Automation Enthusiast
  • 5 replies
  • 0 kudos

Date Calculation Based on Duration of Workdays

I'm hoping someone can help me with a date formula and how to implement it.I've got a project plan (with dependencies) and I've got three fields, "start date" "end date" and duration.The project has a kick-off date and all start and end dates cascade...

How to Check Duration Between Last Modifications?

Hey dear Airtabler!I have a question about tracking the duration between modifications. A user will type a number in the same field several times a day and I would like to check how long each interval took to use this duration in a formula. How to bu...

emmi by 4 - Data Explorer
  • 2 replies
  • 0 kudos

batch_create: How can I format date for API call

Hi,I am getting this error when I try to upload a string valued date to a "Date" type column in airtable using python script. [Error: {\'type\': \'INVALID_VALUE_FOR_COLUMN\', \'message\': \'Field "Uploaded Date" cannot accept the provided value\'}]Wh...

Megha by 4 - Data Explorer
  • 1 replies
  • 0 kudos

Resolved! Finding the Number of Fridays in a Month

Hi all,I'm wondering: Do any of you Airtable experts have an idea how I could calculate how many Fridays (or any other weekdays for that matter) there are in a given month?

Malakai by 6 - Interface Innovator
  • 9 replies
  • 1 kudos

Resolved! Nested IF statement for start date

Dear All,Im trying to create a formula where if an someone starts before the 15th of the month then return the 1st of that month. If they start on the 15th or after then return the 1st of the following month.I have created the below nested IF stateme...

joneill by 4 - Data Explorer
  • 2 replies
  • 0 kudos

Conditional formula on date field in Grid view

Hi All-I am looking to have a conditional field in grid view so that if we are approaching an expiration date, the field will change color according to how soon- e.g. using (TODAY) red if 30 days from expiry, yellow 60 days, green 90 days. So far, I ...

MLH by 4 - Data Explorer
  • 1 replies
  • 1 kudos

Resolved! Create a formula for a view that only shows specific dates

Hello! I need some help from this community because I lack the knowledge to develop formulas.  I really appreciate your help.I'm trying to create a view for a database where I only see records where the answer for "Dates Available" is exactly between...

Joy_Reed by 5 - Automation Enthusiast
  • 2 replies
  • 1 kudos

Resolved! Get Latest Date Summary based on all records in another table

I've used hours to search for a solution via Airtable support pages, this community, Youtube (interesting video) and even ChatGPT, but I can't seem to find an out-of-the-box solution. Hopefully someone like you can help In an Airtable dashboard inter...

Schermafbeelding 2023-02-23 om 10.47.07.png Schermafbeelding 2023-02-23 om 11.36.59.png
stenkate by 6 - Interface Innovator
  • 4 replies
  • 2 kudos

Resolved! Calcuulate date based on weekday

Hello,I need to calculate a date. Here is an example:Start date of employee is 2023-05-03. The previous Monday, an email should be sent to the employee.How can I calculate the date based on the weekday.I have a formula, but it only works if employee ...

mushi4ka by 5 - Automation Enthusiast
  • 3 replies
  • 1 kudos