7 of 7 people found this helpful
Yes We can exclude week end in calculation. Create a calculated field
IF DATEPART('weekday',[Date])=1 or DATEPART('weekday',[Date])=7 then "HIDE"
ELSE "SHOW" END
Place the cal.field in filter and select only show.
(1 means Sunday and 7 means Saturday)
How would you show the actual names of the days of the week, and include all 7? i have a calculated field
and if I change weekday to day, it returns just the number. Created is a date/time field in the data source, and I'm looking to have the days of the week listed.
if you keep day then it will return day part of your date. I did not understand your point and can explain bit more