Hi Michael,
I bet their are multiple ways to accomplish this, but here’s the approach I’d start with. Firstly, assuming you need your formula to determine two things:
- The number of days between the ‘Birthday’ date field, and the current date.
- Is the ‘Birthday’ date field in the future, or the past?
For the first, you can use:
DATETIME_DIFF({Birthday}, TODAY(), 'days')
For the second part:
IS_AFTER({Birthday}, TODAY())
Bringing them together in one formula:
IF(AND(
DATETIME_DIFF({Birthday}, TODAY(), 'days')<8,
IS_AFTER({Birthday}, TODAY())
),"Return True","Return False")
Untested, but hopefully it works for you or at least points you in the right direction. Cheers!
Hi Michael,
I bet their are multiple ways to accomplish this, but here’s the approach I’d start with. Firstly, assuming you need your formula to determine two things:
- The number of days between the ‘Birthday’ date field, and the current date.
- Is the ‘Birthday’ date field in the future, or the past?
For the first, you can use:
DATETIME_DIFF({Birthday}, TODAY(), 'days')
For the second part:
IS_AFTER({Birthday}, TODAY())
Bringing them together in one formula:
IF(AND(
DATETIME_DIFF({Birthday}, TODAY(), 'days')<8,
IS_AFTER({Birthday}, TODAY())
),"Return True","Return False")
Untested, but hopefully it works for you or at least points you in the right direction. Cheers!
In the future. For instance, what birthdays are coming in the next 7 days (or in 1 week when you think about it). Would either filters be the same thing? I tried the filter IS_AFTER({Birthday}, TODAY())
, it…almost worked. It does show the next 7 days but one would show the next few weeks away, I need just the next 7 days/1 week.
In the future. For instance, what birthdays are coming in the next 7 days (or in 1 week when you think about it). Would either filters be the same thing? I tried the filter IS_AFTER({Birthday}, TODAY())
, it…almost worked. It does show the next 7 days but one would show the next few weeks away, I need just the next 7 days/1 week.
@Michael_Harris You need to use the entire formula that @Kris provided, not just that one part of it.