how to Exclude Sat and Sun in Date variable?

[#1]

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

[Anonymous]

Something like vTodaydate =if(Today()=Weekstart(Today()),date(Today()-3 ),date(Today()-1 ))??

[tresesco · Accepted solution]

Try like:

vTodaydate =FirstWorkDate(Today()-1,1 )

[#4]

if ran report on Sunday its giving Saturday data.