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
try this as a formula date field
Case(DayOfWeek([date field]), // the day of week is 0 for Sunday and counts up from there
0,[date field]-Days(2), // if Sunday, subtract 2 days to get Friday.
6,[date field]-Days(1), // if Saturday subtract 1 day
[date field]) // else just use the date
Case(DayOfWeek([date field]), // the day of week is 0 for Sunday and counts up from there
0,[date field]-Days(2), // if Sunday, subtract 2 days to get Friday.
6,[date field]-Days(1), // if Saturday subtract 1 day
[date field]) // else just use the date