Hi, I’m attempting to solve for the posted date/time of an item.
Desired result: date & time of post for a new item.
Available data: each item has some information about the time, but is listed in one of the following formats:
- x minute(s) ago
-x day(s) ago
-x week(s) ago
Success criteria: the best approximation of an items posted date/time understanding that “a week ago” could actually mean 7-13 days ago but, for my case, I can accept this as 7 days ago. The desired results will contain a date and time.
I’ve tried to use the “created time” field and find a way to subtract the time unit(s) I’m provided with, but to no avail.
Is there a way to accomplish this in Airtable?
Thank you in advance.