Startofweek and endofweek in a filter don't work on Fridays.

Question

I have a filter that uses the following:

created >= startOfWeek(-9d) AND created <= endOfWeek(-9d)

This works fine normally, but the last 2 fridays (5/4 and 5/11) the results seem to assume it's the week before!  So for today it shows April 17, 2018 through May 3, 2018.

It goes back to normal on Monday.

Any suggestions??

Victoria Harpe · Answer

the -9d works every other day of the week.  And in fact it seems to be working today.  Perhaps it's an anomaly?

Deyves · Answer

Hi Victoria,

Just to make sure that we're on the same page, could you please confirm what's your goal?

Also, I noticed that you're using the startOfWeek(-9d) but this is not valid. What happens if you remove the "-9d" and run the filter again?

Kind Regards,
Deyves Senger