I got help last week with a problem looking for data for specific days of the week. Someone answered and suggested the following formula to retrieve data for Sunday & Saturday.
{CollectDate} in dateadd("ww",-4,currentdate) to
currentdate and dayofweek(collectDate) in [1,7]
This formula worked, but I only retrieved data from the last week of Sepember. I need the full month of September. Can anyone help?
Thanks... Rosy1
{CollectDate} in dateadd("ww",-4,currentdate) to
currentdate and dayofweek(collectDate) in [1,7]
This formula worked, but I only retrieved data from the last week of Sepember. I need the full month of September. Can anyone help?
Thanks... Rosy1