Using CR V7, I am trying to write a formula to make holidays display as red text. The following formula is accepted with no errors but it is not diplaying red.
DateVar Array Holidays:=Date(2001,1,1);Date(2001,1,19);Date(2001,5,31);Date(2001,7,4);Date(2001,11,23);Date(2001,11,24);Date(2001,12,24);Date(2001,12,25);date(2001,12,31);
If {datefield} in Holidays then Red else DefaultAttribute
Any ideas? Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office
DateVar Array Holidays:=Date(2001,1,1);Date(2001,1,19);Date(2001,5,31);Date(2001,7,4);Date(2001,11,23);Date(2001,11,24);Date(2001,12,24);Date(2001,12,25);date(2001,12,31);
If {datefield} in Holidays then Red else DefaultAttribute
Any ideas? Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office