Formulas | Airtable Community

Resolved! Show current time NOW() in 'America/Los_Angeles'

I'm using formula: SET_TIMEZONE(NOW(),'America/Los_Angeles') I want it to show the current time in LA but it keeps returning the UTC time instead. Any idea what's wrong with the formula?

Resolved! DATE ADD is calculating from an hour before it should.

Hi I have a formulaDATEADD({Kick off},{Time Estimate (Fibonacci Minutes)},"minutes") Whereby {Kick off} is an date field set to ISO and 24 hour time{Time Estimate (Fibonacci Minutes)} is a drop down with a Fibonacci sequenceI want the DATEADD formula...

Date and time formula

I am using a date and time field that shows in ET- i.e 9/22/2023 11:00am. It was showing up in a weird way in automations, so i followed a formula that i saw in a pervious post to format it -DATETIME_FORMAT({Launch Date & Time},'M/D/YYYY \\at h:mma')...

Formula field that chooses earliest date OR gives pending if both blank

Hi everyone,I'm trying to create a formula field that pulls either one of two dates (depending on which one is the earliest) or gives "Pending Date" if both columns are empty. I've tried several different formulas and have gotten close, but I can't g...

Formula to put a distinction on fields with the same data

Hi there!I'm wondering if there's a way I can add a distinction for fields that have the same data. For example, there's two entries that are on the same date (09-22-2023). I have been trying to find out a way to somehow, say, put 09-22-2023a and the...

Resolved! How to force nested if to format as date

Hi folks,I'm have a dataset of events in Airtable with each event as a row, and each row has a different number of sessions that can make up the complete event. This means I have 8 end date & time columns to capture the finish time of each session. I...

time apoiment using last modifede field

Hi,I am using airtable base for my job. I visited persons and I have to repeat this visit every 2 to 4 weeks. When I finished my visit to customer, I wrote in aitable base report and then airtable base recorded the day and time in the last modified ...

Calculating Dates - New to Airtable

Hello all,Brand new to Airtable and like what I see so far. I am trying to calculate a date from two sets of data. In Excel I would have use Start Date + Duration - 1 to get the End Date.I thought I would use the Datetime_Format, but I am getting an...

Resolved! Parsing date from text into an exact Date with specific timezone

I would like to parse a date string of "2023-02-10", with no time information, into a specific timezone (Europe/Malta). We use daylight savings, so right now, 2023-02-10 00:00 Malta time would be 2023-02-09 22:00 GMT. For this reason, I cannot speci...

Resolved! formula to determine the max of multiple date values

I have a formula that works as is today, but I'm trying to add a condition to it and it keeps erroring out? Was hoping to get some extra eyes on it?What we're doing today is taking 3 different date fields, convert them to a #, and then display the m...