I tested what you suggested in this post but it doesn't seem to work in Pega 7.2 (java_1.7_64).
I created a simple report definition and picked "Previous week" in the filter condition. My locale is en_GB.
When I trace the SQL generated by RD above, it takes end of Saturday i.e. Sunday as the first day of the week.
Previous Week in Report Definition
Database Name InteractionHistory
SQL SELECT "PC0".PXFACTID AS "pxFactID"
, "PC0".PXOUTCOMETIME AS "pxOutcomeTime"
FROM PMIH.PR_DATA_IH_FACT "PC0"
WHERE ( "PC0".PXOUTCOMETIME > ? )
SQL Inserts <2017-12-09 23:59:59.999>
Connection ID 16
High Level Op ID 9823
High Level Op list using a list spec
Object Class Data-Decision-IH-Fact
SQL insert value is December 9th, which is (end of) Saturday. I want it to be end of Sunday.
Is there any other parameter that has precedence over operator locale?