[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Conditional Formatting on a Report

Posted on 2015-02-11
2
Medium Priority
?
85 Views
Last Modified: 2015-02-11
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
0
Comment
Question by:pdvsa
2 Comments
 
LVL 49

Accepted Solution

by:
Dale Fye earned 2000 total points
ID: 40603349
You might try:

Expression: ([Due Date per docs] > Date()) AND ([Due Date per docs] < Date() + 10)
0
 

Author Closing Comment

by:pdvsa
ID: 40603480
Perfect!  

([Due Date per docs] > Date()) AND ([Due Date per docs] < Date() + 10)
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question