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
Thank You, --- I'm a bit closer, but not 100% yet.
I have a field now for MostRecentWeekDay, based on the formula .
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
I'm having trouble writing a report ---My report says, filter on:
If MostRecentWeekDay = Today
Or MostRecentWeekDay = 1 day in the past.
This will show the user all records from yesterday (before I upload the new day's data)... But once I do, I want to get rid of the prior day's data from this report.
Any ideas?
I have a field now for MostRecentWeekDay, based on the formula .
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
I'm having trouble writing a report ---My report says, filter on:
If MostRecentWeekDay = Today
Or MostRecentWeekDay = 1 day in the past.
This will show the user all records from yesterday (before I upload the new day's data)... But once I do, I want to get rid of the prior day's data from this report.
Any ideas?