This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi, I wonder if there is a formula to calculate number of nights between two dates with times.
For instance if I have arrival at 01/09/2022 at 22:00 and departure at 01/11/2022 at 09:00 that evidently means 2 nights in a given place.
Any help and ide...
I have a multiple select field {Services} with entries like:
CIQ
COR SKED
CNL
DLA
TECH STOP
etc.
Since it is multiple select, they can be combined in one record, so many combinations are possible.
I want to use the SWITCH() function to apply to this ...
Is there some way to use only Airtable instruments to calculate the great circle distance between two points?
I have those points with lat and long coordinates and need a formula to calculate the great circle distance (or something close to it, no ne...
Have anyone tried this script yet?
When I run it with Map address field populated by lat, long in degrees separated by comma (exactly how I use same for other maps), the script adds some attachment to every record but them removes it.
In the end of t...
I now have the same problem with this script. Although Map Static API is enabled, the behavior is the same - an image is attached, but then removed.
Does anyone have an idea?
Indeed, date fields are tricky.
I can not remove time because that’s exactly what I need to calculate - number of nights between two given dates with times - I know arrival date/time and departure date/time and need to find out how many nights passed...
Databaser:
DATETIME_DIFF({Departure}, {Arrival}, “days”)
Thank you again @Databaser. This formula also produces strange result:
Arrival = 01/10/2022 22:00
Departure = 01/12/2022 13:00
The result is 1, which is not true as 2 full nights should ...
Thank you @Databaser, it does not calculate correctly in the following situation:
Arrival ({other date} = 01/09/2022 22:00
Departure ({most recent date}) = 01/11/22 23:00.
Your result is 3, which is not correct as only 2 nights have passed.
Thanks again @kuovonne.
Unfortunately formula field reference does not say anything about “pattern” or “result” possibility to be formulas. We learn it experimental way :grinning:
