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:...
I am trying to create an application for tracking my travel. I would like to have the following fields: Flight1DepartureDate Flight1DepartureTime Flight1DepartureTimeZone Flight1Airline Flight1Number Flight1DepartureCity Flight1DepartureAirport Flig...
Hi everybody :slightly_smiling_face: ! I working on a simple DATETIME_DIFF() formula but the results I get seems off by on day and I really don’t understand why :confused: … Thus, I don’t seem to be able to correct that :confused: … The current...
I need a formula to find the last day of last month, no matter what day it is in the current month. Example, if today is May 10, I need to return April 30th. If today is May 15, I need to return April 30th. If today is June 30, I need to return May ...
So, I’m still busy working on my “Pets” base, trying to refine it adding formulas here, tables there, linking things… But I’m currently stuck on a “How to” kind of problem :roll_eyes: . Well, to be clear, I can’t see how to go from “this” to “that”...
I’m working on a ‘currently open?’ routine in support of a user question. My formula takes today’s datestamp in the format 'YYYY-MM-DD'; appends ' ' plus an opening or closing time ('HHmm') based on day-of-the-week, taken from a table; and wraps the...
I created a bunch of entries with start and finish times such as 10:00 / 14:00 a couple of months ago. Now that we’re out of BST and into GMT they’re all noted as 11:00 / 15:00 - i.e. they appear to be absolute time values displayed in the browser’s ...
The month display, by using set_locale, starts Uppercase: October, November. When I use this function to display the Dutch month, it starts off Lowercase: oktober, november. Is it possible to adjust this?
I’m using Airtable to keep records of events all over the world. The events have a date and time attribute, with time in different time zones. I can’t find a way to add the TZ information to the time, it seems that the only option is to set all times...
Trying to put together a formula that will return a blank result or a date in a specific format and timezone. This works: DATETIME_FORMAT(SET_TIMEZONE({Broadcast Date/Time}, ‘Australia/Sydney’), ‘DD/MM/YYYY HH:mm’) And so does this: IF({Broadcast Dat...
