Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Trying to create weekend only cases formula

Status
Not open for further replies.

mvalley

Technical User
Mar 4, 2011
80
US
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
 
Depends on what you mean by "Display"

You can put a line in your Select formula like: DayofWeek({case_record_cr_prdate}) in [1,2]
You can suppress a section with a formula like: not(DayofWeek({case_record_cr_prdate}) in [1,2])
 
Thank you. Your second suggestion, "You can suppress a section with a formula like: not(DayofWeek({case_record_cr_prdate}) in [1,2])" worked. Thank you so much. Mary
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top