Color coding report based on Date Modified
Hi all! I'm trying my hand at color-coding a report based on any records updated in the past 7 days. I found a few similar threads/tried to emulate the formulas, but it's giving me guff because Date ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp, that built in field for [Date Modified] is actually a Date / Time field type. Soi we need to convert it to be just the Date. Try this:
IF(
ToDate([Date Modified])<=Today() - Days(7),"green")