Skip to Content
0
Former Member
Jun 10, 2009 at 05:51 PM

"Currentdate -1" excluding weekends

36 Views

Hello,

I search the Internet and this forum, did not find a free answer, so am posting here but apologize if it has already been covered.

I want to pull a list of all recorded that were opened the previous business day. So, when I run this report on Monday morning, it needs to show me how many records were created on Friday.

I know that

{open.date} = currentdate - 1

is fine if I wanted weekends but what do i need to do to exclude Saturday and Sunday.

Thank you.

Regards,

Stephen