updating hard coded date in formula

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

Post Flair (click to view more posts with a particular flair)

Question: Formulas

Post Body

I have a view that I use to review items where specific fields have changed within a particular time span.

I have a field called Recently Updated that has the timestamp of when the fields I care about changed, then I have a formula that flags those:

IS_AFTER({Recently Updated}, DATETIME_PARSE('2020-12-18-00-00', 'YYYY-MM-DD-HH-mm')

Depending on <reasons>, I can't always look back a particular number of days exactly - so I need to hardcode a specific cut-off time that's slightly different every week- so I manually update the formula with a new time every week. Anyone know if there's an easier way to do what I'm doing?

Author

Account Strength

100%

Account Age

8 years

Verified Email

Yes

Verified Flair

Total Karma

7,863

Link Karma

515

Comment Karma

7,338

Profile updated: 2 days ago

Posts updated: 1 day ago

angryweasel1

Subreddit

r/Airtable

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.

Posted: 3 years ago
Reddit URL: View post on reddit.com
External URL: reddit.com/r/Airtable/co...