TecknoFreak
Member
- Local time
- Yesterday, 20:45
- Joined
- Dec 21, 2021
- Messages
- 57
Hello World,
I need to include in my reports all records been done from Starting day [Saturday] Ending day [Friday] = (today for example)
I have it as this
The problem I have is that for example today, I make the report and still give me the previous week report instead of giving me this week Report starting Saturday Dec 18th, ending today Friday Dec 24th.
The Criteria I use works perfectly fine but I have to wait until Saturday (tomorrow) in order for me to get this week report even-though I always make the reports on Fridays.
How can I archive this using a Criteria?
Start day = Saturday
End day = Friday (today)
Thanks,
I need to include in my reports all records been done from Starting day [Saturday] Ending day [Friday] = (today for example)
I have it as this
Between Date()-(6+Weekday(Date(),7)) And Date()-Weekday(Date(),7)
The problem I have is that for example today, I make the report and still give me the previous week report instead of giving me this week Report starting Saturday Dec 18th, ending today Friday Dec 24th.
The Criteria I use works perfectly fine but I have to wait until Saturday (tomorrow) in order for me to get this week report even-though I always make the reports on Fridays.
How can I archive this using a Criteria?
Start day = Saturday
End day = Friday (today)
Thanks,