I have {Date} in one column and am trying to list the corresponding day of the week in another column using the following formula: DATETIME_FORMAT({Date}, “dddd”) For most of my records, the correct day of the week is returned. However, I have at lea...
Hi, Pros, I want to ask, I noticed a confusion for quite a while when it comes to traveling. For instance, if I had filled a time entry when I was in LA, let’s say 11:00 AM (Los Angeles Times). After arriving in Zurich, this entry will be automatical...
Hello all! We are creating a table with a list of events that are occurring around the world. We import lists from partners with the event dates and times listed in the event location’s local time. For example: Dinner 7:00 PM December 1, 2019 Locatio...
Hi everyone, I am brand new at spread sheets and formulas and just trying to create a simple database to make my daily workflow more efficient. At the moment I am struggling with the time zone nuances in airtable. I think I have worked out the formul...
I’ve tried this multiple ways by either having hours be a number field and having the formula be DATEADD({Start date}, Hours, ‘hours’) or as it is now with a duration field and saying DATEADD({Start date}, Hours, ‘seconds’) And the hours are always...
So, I have a date column in a table Screencast.com 2019-08-16_1252 Shared from Screencast.com What I want to do is in another table, if the Tank column reads SPS or Nano, return the earliest dat...
Hi all, i have a field with a text like this " 1 april". Can it be converted into 01/04 plus current year? ty all
I found this formula here that has been working OK but I need to adjust it slightly and I’m not sure how. VALUE(DATETIME_FORMAT({Show Date},‘w’))- VALUE(DATETIME_FORMAT(DATETIME_PARSE(‘01’&DATETIME_FORMAT({Show Date},‘MM’)&YEAR({Show Date}),‘DDMMYYYY...
Why is this showing me tomorrow’s date? Screenshot IF({How Many Days}>6,{Bill Date},IF(AND(Upload=1,{tracking-number}=BLANK()),TODAY(), {Last Update Tracking}))
I have a date field by name Due Date. Another field by name Formula is a simple formula as follows:- IF({Due Date} != "", {Due Date}, SET_TIMEZONE(TODAY(), 'America/Los_Angeles')) Hence, if Due Date is empty, it simply sets the current date. If Due D...
