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
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...
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...
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...
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...
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...
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 ...
Currently CREATED_TIME() function return time in GMT zone. How could I request it return time in other time zone? I read the API but didn’t find a parameter to pass the timezone information. Thanks.
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 ...
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...
