pdvsa
asked on
Conditional Formatting on a Report
Experts, I have a report with a field [Due Date per docs] (I know this is not named correctly but it is an import from excel data). I have another field [Description] and I need to conditionally format this field [Description] if [Due Date per docs]>Date() And Date()+10 but this doesnt seem to conditionally format [Description]. In the Rules Manager I have Expression is: [Due Date per docs]>Date() And Date()+10 then I hit apply.
How can I conditionally format this field [Description] based on the criteria of [Due Date per docs]>Date() And Date()+10
thank you
How can I conditionally format this field [Description] based on the criteria of [Due Date per docs]>Date() And Date()+10
thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
([Due Date per docs] > Date()) AND ([Due Date per docs] < Date() + 10)