Is it possible to create a saved search showing the total GL account balance as of every Friday in the past 3 months? Rolling but as of every Friday only. It seems possible to do it every week but making it as of every Friday only is challenging to me.

Maybe try to add a formula numeric in the criteria to get the day of the week TO_NUMBER(TO_CHAR({date},’DD’)) is less than 6

Thank you. I used 'D'.

just to add you can use the format mask

DAY

or

DY

so that it's system/user agnostic Especially if you allow the First Day of Week preference to be overridden (Setup > Company > General Preferences > "Overriding Preferences" tab)

Ahhh thanks @David B