Highlight Search Results Alternating by Month

To highlight the search results alternating by month, follow the steps below:

1. Create a Saved Search, List > Search > Saved Searches > New > Customers
2. On the Criteria Tab, you may enter any criteria desired.
3. On the Results Tab, add the Date Created Field and all other field you want to add.
4. Set Sort By = Date Created
5. Navigate to the Highlighting Tab and Click the Set Condition Button.
6. Mark Use Expressions = T and set the following filters.

Note: You may use any Date field on this search. You will just need to replace the formula field found on the Highlighting tab instead of Date Created.

Filter	Description	Formula	And/Or
Formula (Text)	is 02	to_char({datecreated},'MM')	Or
Formula (Text)	is 04	to_char({datecreated},'MM')	Or
Formula (Text)	is 06	to_char({datecreated},'MM')	Or
Formula (Text)	is 08	to_char({datecreated},'MM')	Or
Formula (Text)	is 10	to_char({datecreated},'MM')	Or
Formula (Text)	is 12	to_char({datecreated},'MM')	Or

7. User may change the color of the background after you click the Set button.
8. Save and Run the Search.