You need to sign in to do that
Don't have an account?
Zoom_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 ?
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)