Sysdate Minus weekend

building reports webintelligence
1

Hi all,

I am trying to compare a due date along with the sysdate to verify if the users completed the assignment or not.

But i want to exclude weekends from sysdate. Is it possible?

alexks (BOB member since 2008-03-25)

2

What you want as output Date or Days?

For days excluding week days you can find the some tips in below post

https://bobj-board.org/t/157452

Rajubollas :india: (BOB member since 2009-09-04)

3

For days:

Create 3 Variables:

  1. V_WeekLastday
=LastDayOfWeek(CurrentDate())
  1. V_WeekLastday-1
=RelativeDate(LastDayOfWeek(CurrentDate());1)
  1. V_WeekdayDate
=(CurrentDate()) Where (Not (CurrentDate()=[V_WeekLastday-1] And CurrentDate()=[V_WeekLastday] ) )

Third variable will give always week days date only

Rajubollas :india: (BOB member since 2009-09-04)

4

This is also a solution for WeekDate

  1. V_WeekdayDate
=If (CurrentDate()=LastDayOfWeek(CurrentDate());"Null";If(CurrentDate()=RelativeDate(LastDayOfWeek(CurrentDate());1);"Null";CurrentDate()))

Rajubollas :india: (BOB member since 2009-09-04)