Last day to be Friday if Current day is awalys Monday

[Anonymous]

Hi,

Looking for a way to make the Last Day a Friday if current day is a Monday.

vCurrrentDay = DAY(MAX(iDate))

vPreviousDay = DAY(MAX(iDate)-1)

Thanks

[#2]

hi,

Use this script

  vPreviousDay = if(WeekDAY(MAX(iDate))='Mon', Day(MAX(iDate)-3), Day(MAX(iDate)-1))

Reagrds,

Vivek

[tresesco]

Something like:

vPreviousday=If(WeekDay(Max(iDate))='Mon', Day(Max(iDate)-3), DAY(MAX(iDate)-1))

[Anonymous]

Hi,

Try below,

vPreviousDay = Day(If(WeekDay(Max(iDate))='Mon', Max(iDate)-3, Max(iDate)-1);