Help
Other questions
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

DATETIME_DIFF unexpected results

Hello! I’m an item reseller who has been experimenting with DATETIME_DIFF to show me how long an inventory item was listed for before it sold, but I’ve been getting unexpected results. It’s possible I’m doing something very wrong, so if you could ple...

Resolved! Unable to enter full formula

Hi, I am entering the following formuula but after pressing save the formual appears with the end missing WHAT I ENTER IF({1st Sow Date}=BLANK(),"",DATETIME_FORMAT(DATEADD({1st Sow Date},{Min Germ Days},‘Days’)),‘DD/MM/YYYY’) WHAT APPEARS AFTER I PRE...

Mark_Anson by 5 - Automation Enthusiast
Solved
  • 2012 Views
  • 7 replies
  • 2 kudos

Add a Look Up Field to a Date Field

Hi, I cant seem to get this to work… DATEADD({1st Sow Date},SUM({Min Germ Days},‘Days’)) {1st Sow Date} is a Date field with Manually entered Data and {Min Germ Days} is a lookup field from another table. The output is the same as the date of {1st So...

Mark_Anson by 5 - Automation Enthusiast
  • 852 Views
  • 2 replies
  • 0 kudos

Convert Text to Date

I have the data in one column: 2018-11-08 10:21:59 PST 2019-02-26 07:26:44 PST 2019-02-04 08:08:18 PST 2019-03-11 07:47:03 PDT This is now a text field, how can I convert this to a date field ? I will will use a new column but what is the Formula to ...

Date Formula Error - Configuring help!

I can’t figure out where I am going wrong in my formula below. It seems like it should be simple, but maybe I am going about it the hard way. I have: {Created Time} & " - " & {Notes} I want to have the Primary Field display the created date and time ...

AT Note View Problem

New year problem with Week #

So i have a simple formula for calculating the week number to make grouping the records easier. When 2020 came around it got grouped with 2019 so i switched it to a DATETIME_FORMAT to show both year and week. ezpz should be solved. But noticed that f...

2020-01-09 12_44_27-Shipment Tracker_ Yggdrasil - Airtable 2020-01-09 12_45_01-Shipment Tracker_ Yggdrasil - Airtable
Emil_Lilja by 5 - Automation Enthusiast
  • 1601 Views
  • 4 replies
  • 2 kudos

Calculate 1st day of next quarter from contract enddate

Calculate 1st day of next quarter of contract enddate For an office rental company I’m using a base to administrate rental contracts. Each rental contract has an enddate on one of the Quarter startdates. I.e. a contract can only end on: Quarter 1 (1s...

Guido_Kok by 4 - Data Explorer
  • 1099 Views
  • 0 replies
  • 1 kudos

Resolved! Use calculated Time Zone in Formula

Hello I am trying to create an interview tracker. I have the following fields: Interview ID - formula Candidate - lookup Client - lookup Interview Date - Date, US format with 12 Hour time, Using GMT for all collaborators. Interview Time Zone - Single...

Can't get TODAY() to know when today is

I have a very simple formula request that is blowing my mind right now. I don’t know why this is so difficult. If the field {Due Date} is today, return the value “Due Today” in the formula field. First I tried: IF({Due Date}=TODAY(),“Due Today”) Pret...

James_Trory1 by 5 - Automation Enthusiast
  • 7490 Views
  • 10 replies
  • 3 kudos

Resolved! Return Days and Hours from 2 Date/Time Fields?

Hello fellow Airtablers. I’m looking for something pretty specific, but not sure if it’s even possible. I have a “Created Time” field and a “Completed Date/Time” field. What I’m looking to create is a field with a formula that will generate both the ...

Days%20%26%20Hours%20Spent%20Example

Resolved! DATETIME_FORMAT returning wrong day of week

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...

Paul_Miller by 6 - Interface Innovator
Solved
  • 1774 Views
  • 3 replies
  • 1 kudos

Edit an entry from different Timezone

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...

Xing by 6 - Interface Innovator
  • 564 Views
  • 0 replies
  • 0 kudos

Time Zone questions - managing events around the world

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...

spark1001 by 4 - Data Explorer
  • 2570 Views
  • 0 replies
  • 0 kudos

Incorporating SET_TIMEZONE into a formula

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...

Creating an End Date by adding duration to a Start Date

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...

Parker_Web by 5 - Automation Enthusiast
  • 8970 Views
  • 9 replies
  • 4 kudos

Return Date based on another field

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...

aa722137b603139ebdb412c5a7bf153acf329e13.gif
wrasse by 5 - Automation Enthusiast
  • 994 Views
  • 1 replies
  • 0 kudos