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

Forum Posts

Assign week number per month

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

07-08-53-17
Tim_Young by 6 - Interface Innovator
  • 3678 Views
  • 1 replies
  • 0 kudos

Show Tomorrow Date

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}))

Unable to set timezone correctly for TODAY()

Hey guys, I have a quick question, looks like a straight forward one. I have a simple {Due Date} field which is of type Date. I’ve created a new field {Due Date?} which simply calculates to {Due Date} if the {Due Date}'s value is present, else calcul...

DATETIME_PARSE({UNIXTIME},'x', 'EST')

I keep getting ERROR code My formula is DATETIME_PARSE({UNIXTIME},‘x’, ‘EST’) How can I convert a 13 digit unix time stamp into a date like this: 2/7/2019 8:09pm I have this:1549584840000 I need this: 2/7/2019 8:09pm

BobBannanas by 6 - Interface Innovator
  • 2759 Views
  • 3 replies
  • 0 kudos

Due Date is this week or next week forumula

I’m trying to come up with a formula to denote if something is due “This Week” or “Next Week” but can’t seem to nail it down. I’ve tried using this: IF((WEEKNUM({Due Date}, IS_SAME(WEEKNUM(TODAY())))) Airtable accepts the formula, but I get an #ERROR...

Adam_Zeis by 4 - Data Explorer
  • 6834 Views
  • 13 replies
  • 5 kudos

If date is within range, then true

I’m trying to replicate the IF formula in this sample google sheet: https://docs.google.com/spreadsheets/d/1Q_UJ9bL-7XGbDl3Mok9vYS3cSsD1BybAFYNc0j9WV9A/edit?usp=sharing I need to count how many hotel rooms nights I’m using on a given night, which wil...

Time String from a Date Cell displayed in a Formula Cell

Hello! Each time I try to display the time I choose in a date cell, I get the displayed hour - 1 hour. I set the time in a date cell. Example: ‘6/12/2018 06:30’ I should get in the cell with a formula the ‘06:30’ string. Instead I get ‘05:30’. Here i...

Greenshot 2018-12-06 11.28.05.png
Eduard_Ichim by 5 - Automation Enthusiast
  • 1495 Views
  • 2 replies
  • 0 kudos

Trigger if something does not occur

I’d like to show a record in a view if something does not occur by a given time in the user’s time zone. The use case is that the users submit a form each day. If they do not submit the form, they should go into a particular view. I’m having problems...

Lookup field not pulling the correct date

Hello! I have a lookup field in one table to copy over a date from the connected record. This has been working fine, except for one entry that for some reason is displaying the lookup date as the day after the actual date from the connected record. A...

Time Not Changing On Formula Field

I have a formula field as follows: DATETIME_FORMAT(SET_TIMEZONE(NOW(), ‘Australia/Sydney’), ‘HH:mm’) However, the field seems to remain static - the time never actually changes Can anyone spot an error in the formula, or is there a better way to do ...

DATETIME_DIFF() and Incorrect Timezone

Hey there, Airtable Experts… I have created a simple task table where I am attempting to use a formula field to automatically categorize individual tasks based on their due dates, i.e., Overdue, Due Today, Due Soon (2 days or less), etc. I have used ...

Wayne_Olson by 5 - Automation Enthusiast
  • 3644 Views
  • 10 replies
  • 7 kudos

Created date time field has wrong timezone

I’m using Zapier to create a new record in one of my bases. The Zapier web hook is sending a date and time that looks like “2017/05/12 7:07:51 PM”. I have a datetime field in my base that receives that data, but it gets converted as though the incom...

Task_History_828aeded-f889-42aa-9015-24b3ed34e717_-_Zapier 2.png Task_History_828aeded-f889-42aa-9015-24b3ed34e717_-_Zapier.png
Tim_Wilson by 7 - App Architect
  • 4324 Views
  • 3 replies
  • 3 kudos

Setting current time in different timezones

I’ve reviewed some posts, but I might just not understand how to do this. I have multiple freelancers that live in different time zones around the world. Each freelancer has a record into my document with their contact info and their timezone. I want...

Automate Creation Of New Record

I have records in one table, and when a checkbox is selected, I would like that record to be copied to another table in the same base. The reason for this is that I am pushing information from Airtable into another app. However, because Airtable lack...

DATEADD functions adds days but also changes the time

I have 2 fields {Old Dates} and {New Dates}. I want to use a formula to increase {Old Dates} by 7 days and keep the same time. {Old Dates} 7/16/2018 18:00 {New Dates} 7/23/2018 6:00pm Unfortunately, when I use the formula function DATEADD({Old Dates}...

DATEADD formula issue

I have 2 tables … both have the same fields for calculating the expected return time for a rental, based on the OUT AT date/time and a DURATION field. A third field ESTIMATED RETURN is a formula field for calculating the return time. The formula is:...

J_Allen by 6 - Interface Innovator
  • 1342 Views
  • 1 replies
  • 1 kudos