Most Recent WeekDay Field
I need help constructing a formula field (if possible). Each day I import records to a table from another platform, and include a date apart of that record called "Data Date" so that users are able to...
Forum Discussion
OK, I get it.
I think that the answer is to create another field called [Today or the Previous Friday].
The formula will be similar,
Case(DayOfWeek(Today()), // the day of week is 0 for Sunday and counts up from there
0,Today()-Days(2), // if Sunday, subtract 2 days to get Friday.
6,Today()-Days(1), // if Saturday subtract 1 day
Today()) // else just use the date
Then filter the report where
[MostRecentWeekDay] is equal to the value in the field [Today or the Previous Friday]
I think that the answer is to create another field called [Today or the Previous Friday].
The formula will be similar,
Case(DayOfWeek(Today()), // the day of week is 0 for Sunday and counts up from there
0,Today()-Days(2), // if Sunday, subtract 2 days to get Friday.
6,Today()-Days(1), // if Saturday subtract 1 day
Today()) // else just use the date
Then filter the report where
[MostRecentWeekDay] is equal to the value in the field [Today or the Previous Friday]