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

Forum Posts

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
Solved
  • 39696 Views
  • 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
Solved
  • 2839 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
  • 296 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
  • 888 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
  • 959 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 ...

Date Limited Rollup Field Not Working?

I have a table of events that all have a start and end time/date.  The start field is "Start Datetime"For example, I have event that has a start datetime of 1/1/2019 at 11:00am.  All in a date field.  1/1/2019 specificially we use as a generic fallba...

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
Solved
  • 835 Views
  • 2 replies
  • 2 kudos

Automation publishing wrong dates in google calendar

Hi all!I'm using Airtable to track leave requests and automatically add peoples approved leave requests to Google Calendar. Currently, I have 'Leave Start Date' and 'Leave End Date' date fields which are used as the 'Start Date' and 'End Date' of the...

user_533 by 5 - Automation Enthusiast
  • 477 Views
  • 2 replies
  • 2 kudos

Resolved! How do you filter items by year?

I have searched for how to do this, but it seems unclear. There is no way to group by year, specifically. You can only select past year, next year, specific number of days, etc. So how do you group items by year?

Anxious by 7 - App Architect
Solved
  • 462 Views
  • 2 replies
  • 2 kudos

Locking to a time zone

This seems to be a commonly asked question but I am yet to see an answer that works for me. I am trying to build a base which will manage activity in our building in London UK. There is never a time that I don’t want any times entered to be treated a...

Help with autopopulated dates and calender

I've figured out how to create a formula that outputs a date that Airtable understands as a date (rather than a string of data) and have it appear on a calendar BUT is there a way to be able to drag said  item across the calendar so the dates change ...

nasw95 by 4 - Data Explorer
  • 422 Views
  • 2 replies
  • 0 kudos

Resolved! Filter by a specific day of last month

I've set up a Table for recording my Staff working hours, moving from a paper system. Each day the staff member using a form, enters the date, name and number of hours worked, site location etc. When its time for payroll I want to create views that f...

sehenley by 5 - Automation Enthusiast
Solved
  • 651 Views
  • 3 replies
  • 2 kudos

Calendar sync - Timezones

In airtable, I've programmed a calendar with dates and times for specific events. The formula is as follows: IF({Override horaire cour 1}=0,IF(Ordre="1", DATETIME_PARSE(DATETIME_FORMAT({début},'MM/DD/YYYY')&' '&{Horaire c1h1}), DATETIME_PARSE(DATETIM...

abbi by 4 - Data Explorer
  • 852 Views
  • 0 replies
  • 0 kudos