Time Filter

neg177

Need advice best way to set up a Time Filter in my Daily Model that gives me only the Weekdays and not the Weekends. Please Advice. 

 

Thank you 

rob_marshall

@neg177 

DayofWeek() will be your friend here.  That will return a number.  Create a line item for Weekdays with the formula: if DayofWeek line item < 6 then 1 else 0.

 

Rob

neg177

Hi,

 

Got it, 

 

Thank you