If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional format and comparing dates
How do I do this on a report?
If the difference between date1 and date2 is greater than 42 days then date 1 should be bold, else nothing. date1 is the control cell in which I'm trying to enter the formula but I'm coming up with nothing. |
#2
|
|||
|
|||
Conditional format and comparing dates
Hank wrote:
How do I do this on a report? If the difference between date1 and date2 is greater than 42 days then date 1 should be bold, else nothing. date1 is the control cell in which I'm trying to enter the formula but I'm coming up with nothing. Try using the Expression Is" option with something like: DateDiff("d", [date1], [date2]) 42 Note that the [ ] are required. You didn't say which date is the earlier date so you might have to switch the 1 and 2. -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|