We're a publishing company and we keep track of content that we publish over the course of the year with these different columns showing publish dates. I'd like to do 2 things:Create 1 column that combines the dates (combining them so that they remai...
I have a formula field containing NOW() and nothing else. The field is showing the wrong time. Right now it's 3:02 a.m. in the desired time zone (Eastern Daylight Time), but the field shows 2:59 a.m. I've attached a screenshot showing the difference ...
Hi I have two fields ie a created time field and a formula field for the time field. I have an issue with time displayed in the formula field. It seems to convert the time I don't know why,, here is the formula: IF( {Posting Date} > NOW(), "Posted: T...
Bonjour,J'ai dans ma base un champ de recherche qui me permet de récupérer les dates de différents enregistrements liés. Parmi toutes les dates remontées, je souhaite définir quelle est la plus petite (ou la plus grande) : comment faire ?Merci pour v...
How do I write a formula to populate anything that is created in that week, it will add the Monday date of that week. For Example:I have records for 10/7, 10/8, 10/10. I need the Starting Week of to be: 10/7 for all Dates. Then I need records for 10/...
I've been scouring this forum for an answer to a variant of "Convert String to Duration" but alas, no simple answers uncovered!In my case, I have a text field that contains duration as as string such as, "1:30:00."I need this to now be a field that i...
I have a weird one: How would I even begin to convert a column that contains duration data formatted as a string like this? I want the final conversion to be a decimal number, but none of the standard DATETIME() type formulas can make sense of it. He...
Hi everyone,I have been struggling with comparing a date of when a record has been created to a date I am manually inputing into the formula. So basically I am trying to use the IS_AFTER function but have tried so many things and just everything is e...
Brand new to Airtable, so forgive me if this is a dumb question. I've shamelessly stolen a formula to calculate start and end dates based off a T- or T+ from a specific event. DATETIME_FORMAT(DATEADD({Calculated End date},{Days Needed to Complete},'...
Context:I have two different tables: A User Info table, and an Event Request table. the relevant columns User Start Date, Event Start Date and Event End Date.Current Status:I am calculating the duration of the events in the Event Request table, pulli...
