Text formatting from a formula -
09-13-2005
, 02:28 PM
I have a formula (which a few people on this group helped me with a
couple of months ago) that I want to add formatting to the text based
on certain conditions.
Case(
Get( CurrentDate) >= Date( Month(DateofHire)+3; Day(DateofHire);
Year(DateofHire) + 5); "Tenth Anniversary: " & GetAsText(Date(
Month(DateofHire); Day(DateofHire); Year(DateofHire) + 10));
Get( CurrentDate) >= Date( Month(DateofHire)+3; Day(DateofHire);
Year(DateofHire) + 3); "Fifth Anniversary: " & GetAsText(Date(
Month(DateofHire); Day(DateofHire); Year(DateofHire) + 5));
Get( CurrentDate) >= Date( Month(DateofHire)+3; Day(DateofHire);
Year(DateofHire) + 1); "Third Anniversary: " & GetAsText(Date(
Month(DateofHire); Day(DateofHire); Year(DateofHire) + 3));
Get( CurrentDate) >= Date( Month(DateofHire)+3; Day(DateofHire);
Year(DateofHire)); "First Anniversary: " & GetAsText(Date(
Month(DateofHire); Day(DateofHire); Year(DateofHire) + 1));
"Probationary")
The formula calculates the anniversaries of staff employed by our
organization. We would like to have the anniversary highlighted if it
is within the current month and year that the report is run to help as
a reminder.
So if they are celebrating 5 years here in September, the font would
appear bold and italic.
Can anyone offer suggestions for how I may accomplish this? |