Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
i created one variable like below
vDate= Date(Today() -1) this giving Yesterday date
now if i ran the report on Monday this giving Sunday but here i want Friday basically i want exlcude Sat and Sunday
please help
Hi ,
check this out for pointers
Andy
try this
=date(if(weekday(Today())='Mon',Today()-3,Today()-1))