Tuesday, May 14, 2019

Highlight the date field on a saved search results if it is within this year

1. Create a new Transaction Search, List >Search > Saved Searches > New > Transactions.
2. Add the following Criteria:
- Main Line = True
- Type = Cash Sale

3. Navigate to the results tab and add the following:
- Formula (Text):
CASE WHEN to_char({trandate},'YYYY') = to_char({today},'YYYY') then'<font color="red">' || {trandate} || '</font>' elseto_char({trandate}, 'MM/DD/YYYY') end

4. You may change the Custom Label to Date and click Save & Run.

No comments:

Post a Comment