Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi,
Use this script
vPreviousDay = if(WeekDAY(MAX(iDate))='Mon', Day(MAX(iDate)-3), Day(MAX(iDate)-1))
Reagrds,
Vivek
Something like:
vPreviousday=If(WeekDay(Max(iDate))='Mon', Day(Max(iDate)-3), DAY(MAX(iDate)-1))
Hi,
Try below,
vPreviousDay = Day(If(WeekDay(Max(iDate))='Mon', Max(iDate)-3, Max(iDate)-1);