Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
i created one Date variable like this
vTodaydate =date(Today()-1 ) this give result 17/04/2017
Now i want to Exclude Sat and sunday i run report Monday it shoud show only Friday date
please help
Something like vTodaydate =if(Today()=Weekstart(Today()),date(Today()-3 ),date(Today()-1 ))??
Try like:
vTodaydate =FirstWorkDate(Today()-1,1 )
if ran report on Sunday its giving Saturday data.