I am trying to create a formula that only shows cases done on Saturday or Sunday.
The field I have is case_record_cr_prdate. I created a formula called @Saturday that reads: If DayofWeek({case_record_cr_prdate}) = 7 THEN 1 ELSE 0
and a second formula, @Sunday that reads: If DayofWeek({case_record_cr_prdate}) = 1 THEN 1 ELSE 0. I need to display ALL cases done on Saturday and Sunday only.
How can I do that from here? Or is there a better way to obtain this information? Thanks, Mary
The field I have is case_record_cr_prdate. I created a formula called @Saturday that reads: If DayofWeek({case_record_cr_prdate}) = 7 THEN 1 ELSE 0
and a second formula, @Sunday that reads: If DayofWeek({case_record_cr_prdate}) = 1 THEN 1 ELSE 0. I need to display ALL cases done on Saturday and Sunday only.
How can I do that from here? Or is there a better way to obtain this information? Thanks, Mary