I need help.
I can’t workout a formula or workaround to determine if a record with a date field is equal to ‘This Week’ (being: this block of Monday to Sunday), and then count a field if the outcome is true.
I know how to see if the record’s date is within the last 7 days:
IF(DATETIME_DIFF(NOW(),Date,'days') < 7,ValueToAdd,"0")
Even to see if it is within the last week on a particular day:
But still can’t figure out how to make it display the
ValueToAdd if it happened between this particular block of Monday – Sunday.
If a record’s date is Friday (for example) and checked on a Friday, the value should report.
But when checked the following Monday, the value should = 0.