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
@maretval Hello, how current week works? I have current week as filter, but it is displaying data from the 1st & 2nd week of January.
Does it consider Monday to Sunday as week?