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

Forum Posts

Resolved! How to include multiple dates for a single item

Hi there. I am not a habitual Airtable user, nor am I much of a tech person, so I apologize if this question has been answered and I wasn't able to find it.I am developing a database for my perfume collection using Airtable, and for most parts of thi...

lightkensei by 4 - Data Explorer
  • 3 replies
  • 2 kudos

Resolved! Choosing the time zone used for Date and Time functions

I am in Seattle, using my local time zone, Pacific Standard Time (GMT -8). One of my columns, ‘Start Time’, contains a Date value of “1/2/2016 10:00”, but when I reference it in a separate column using DATETIME_FORMAT({Start Date}, ‘MM/DD/YY HH:mm’) ...

Chris_Rutledge by 5 - Automation Enthusiast
  • 66 replies
  • 116 kudos

Dates and Formulas

I’ve searched, googled and tried all the formulas I’ve found and nothing is working. I feel like I’ve spent more time working on these dang formulas than the table itself. Any help is greatly appreciated. Also, if anyone knows anywhere I can test a f...

Resolved! Date order not quite right in a linked record

I am a historian, constructing a historical database (1940s-60s). When I click on my linked record for a person or institution, some of which will have to link to 1000+ records, I notice that the records are almost arranged in date order - but not qu...

Sebastian_Page by 5 - Automation Enthusiast
  • 14 replies
  • 1 kudos

Filter "the past number of days" counts today in?

Hello all!I use airtable e.g. for recording and analyzing event data. In event data i have "start" date and time, and "end" date and time.When I set the filter "the past number of days" (e.g. 30 days) to the event data, it would appear that the curre...

Rollup Filters not working?

Hi, Is it only me or are Rollup Filters not working. Tried this with date fields and text ones, and still without any success. Please let me know if there is a solution or it's a temporary bug? Thanks!

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

I need to be able to enter a date without a year

I’m working on an app to keep records for a children’s club. We try to get their birthdays, but sometimes they don’t know the year they were born. Is there a way to enter only the month and day? Ultimately I want to use the date to calculate the age,...

Revision history difference between table and interface

I noticed differences in the revision history of a record when i open it in an interface vs. when i open it on a table. How? Why?in interface, last edit 4w ago (but last edited date shows 1 day ago...):in table the edits from 1 day ago show up. they ...

Davidt_0-1703078230571.png Davidt_1-1703078346077.png
Davidt by 5 - Automation Enthusiast
  • 0 replies
  • 0 kudos

Incorrect time

Hi guys, I have created a "date field". 3:19 pm is my current time, but once I had it created, it showed the wrong time - 12:00am, I tried to click "use the same time zone for all collaborators> GMT/UTC", but the time was still wrong. I don't underst...

Matthihi by 4 - Data Explorer
  • 0 replies
  • 0 kudos