Hi Sharon, yeah, I feel like using DATETIME_DIFF might not be the way to go here. Don’t get me wrong, totally doable, but thinking about all the edge cases around that made my head hurt
If I were you, I think I would use a formula to check whether the created date matched yesterday’s date instead, and I’ve attached the formula below
IF(
DATEADD(Today, '-1', 'days')
=
DATETIME_PARSE(
DATETIME_FORMAT(
Created,
'DD MM YYYY'
),
'DD MM YYYY'
),
"Yesterday"
)
And here’s a link to the base
The base has the Today field set up as a date field purely so that we can see the formula at work
Hi @Sharon_Visser,
The IS_SAME function lets you compare if two dates are the same date, up to any unit that you specify.
So, if you keep both of your fields as GMT, then your formula could look like this:
IS_SAME(
DATEADD(TODAY(),-1,'days'),
{Created Date},
'days')
Hi Sharon, yeah, I feel like using DATETIME_DIFF might not be the way to go here. Don’t get me wrong, totally doable, but thinking about all the edge cases around that made my head hurt
If I were you, I think I would use a formula to check whether the created date matched yesterday’s date instead, and I’ve attached the formula below
IF(
DATEADD(Today, '-1', 'days')
=
DATETIME_PARSE(
DATETIME_FORMAT(
Created,
'DD MM YYYY'
),
'DD MM YYYY'
),
"Yesterday"
)
And here’s a link to the base
The base has the Today field set up as a date field purely so that we can see the formula at work
Thanks @Adam_TheTimeSavingCo - works perfectly!
Hi @Sharon_Visser,
The IS_SAME function lets you compare if two dates are the same date, up to any unit that you specify.
So, if you keep both of your fields as GMT, then your formula could look like this:
IS_SAME(
DATEADD(TODAY(),-1,'days'),
{Created Date},
'days')
@ScottWorld, this works perfectly also!
Can I mark 2 responses as the solution, both your’s and the one submitted by @Adam_TheTimeSavingCo? If I can only mark 1 as the solution, I’ll go with Adam’s since he submitted his first. But I definitely learned something helpful from both of you.
Thanks @Adam_TheTimeSavingCo - works perfectly!
Hi Sharon, I’m glad I could help!
I think that you should mark Scott’s reply as the solution as it’s much more elegant than mine though!
@ScottWorld, this works perfectly also!
Can I mark 2 responses as the solution, both your’s and the one submitted by @Adam_TheTimeSavingCo? If I can only mark 1 as the solution, I’ll go with Adam’s since he submitted his first. But I definitely learned something helpful from both of you.
Lol, you can only mark one solution, but feel free to mark whichever one you want! Like many things in Airtable, there are often 3 or 4 or 5 different ways of accomplishing the very same goal. Sometimes there are even MORE ways of accomplishing the same goal!
