How is current week determined for Select?

We would like to run reports for Saturday at 12a to following Friday at 12:59p. Current Week filter seems to only pull from Monday - Sunday.

Is there a way to change Current Date so we don’t have to edit a between filter everytime the report is run?

Possible operators for date fields cannot achieve what you would like to have. You can only select from a specific date to another one or within n days (weeks or months).
With specific dates you would have to change the report each week.
With n days you would not get the week days as you.
Creating a custom function for function operator might help. Right now I don’t remember how it exactly works. But I think you might be able to pass where clause parameters this way.

1 Like