2 Replies Latest reply: Nov 14, 2011 8:00 PM by John Witherspoon RSS

    Date set comparison

      I have a field called DaysWorked containing a list of about 400 dates.

      I also have a table containing the list of national holidays (HolidayDate), containing about 8 dates.

       

      I wish display the list of DaysWorked, which will be bright red if the date lands on a national holiday. Essentially, if DaysWorked is in HolidayDate, then true. I am having difficulty getting the hang of set arithmetic.

       

      As an extra challenge, Id like DaysWorked to be a duller shade of red if it is +/- 1 day either side of a national holiday.

       

      Im new to QV and BI generally. I would appreciate any help!