function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Zoom_VZoom_V 

Show only previous Business Day on a report

I am attempting to show the previous Business Day's new Accounts in a report. I am unable to simply use Yesterday as the filter because Monday will then show Sunday results, not Friday. The only solutions I have been able to find involve creating a second report which only runs on Monday and shows the results of the previous three days - and then running the other report which shows Yesterday from Tues-Friday.

This solution seems rather over complicated. Does anybody know of a more direct solution to this ?

Robert ZentgrafRobert Zentgraf
Hi Zoom_V,

I think you can use a formular field on the account, which returns true or false. You can use this checkbox as filter for your report.
The formula should use something like DAY(TODAY())=x and DIFFERENCE(CreatedDate, TODAY()).

Regards
Robert

(mindforce: http://www.mind-force.de)