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

Forum Posts

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
Solved
  • 3097 Views
  • 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
  • 339 Views
  • 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
  • 923 Views
  • 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
  • 1010 Views
  • 0 replies
  • 0 kudos

Can I have Year (YYYY) ONLY be read as a date?

Hi! I am using Airtable to create an inventory of items in a museum of education related items. The vast majority of the items in our collection only have a year attributed to the item (i.e. class of '89, picture taken 1976, Spring 1935, etc). I am w...

How to filter by current month?

I have a table that contains subscription dates using the date field. I’m trying to create a new grid view with a filter that just shows dates that fall into the current month. Seems simple, but I can’t figure it out. I can see how I can use the “is ...