I have buttons set up to filter based on date ranges (All Time, Last Month, and Last Week). The All Time and Last Month filters work correctly, but the Last Week filter is having issues.
Here are both my expressions [where vEndDate = Now()]
Last Month: =Date(Addmonths(vEndDate,-1),'M/DD/YYYY hh:mm:ss tt')
Last Week: =Date(vEndDate -7,'M/DD/YYYY hh:mm:ss tt')
I have a trigger set on vStartDate and vEndDate to Select in Field for my date field, where the search string is: ='>='&vStartDate&'<='&vEndDate
If I select Last Month, it sets the search string correctly, but if I select Last Week, it sets - as the date range.
I am also confused because if I change the value I subtract from vEndDate from 7 to an integer greater than 7, the filter seems to work fine.