Trying to figure out correct Date Function...

[BrookieOU]

I am trying to use conditional formatting in a report that shows Benefits
Effective and Benefits Cancellation Dates. The report lists all employees
and their effective or cancellation date. When we add a new employee we
enter the date the benefits are supposed to take effect (or vice versa when
we terminate).

So, for instance, when we add a new employee on 7/1/09 and we enter 9/1/09
as their benefits effective date I want to be able to run this report at the
end of the month of July and the 9/1/09 effective date show up in red so it
will alert us to add them to the benefits.

I have worked through all the date functions and either can't find one that
will work, or I can't make it work. Can someone give me an idea on how to do
this if it's possible?

Thanks!

 

[BrookieOU]

Yay!!!! Thank you so much. That worked like a charm!

Brooke

The following expression will give you the last day of the current month:
DateSerial(Year(Date()), Month(Date())+1, 1-1)
You want to highlight all effective dates greater than the last day of the
current month:
[EffectiveDate] > DateSerial(Year(Date()), Month(Date())+1, 1-1)

Steve
(e-mail address removed)

I am trying to use conditional formatting in a report that shows Benefits
Effective and Benefits Cancellation Dates. The report lists all employees
and their effective or cancellation date. When we add a new employee we
enter the date the benefits are supposed to take effect (or vice versa
when
we terminate).

So, for instance, when we add a new employee on 7/1/09 and we enter 9/1/09
as their benefits effective date I want to be able to run this report at
the
end of the month of July and the 9/1/09 effective date show up in red so
it
will alert us to add them to the benefits.

I have worked through all the date functions and either can't find one
that
will work, or I can't make it work. Can someone give me an idea on how to
do
this if it's possible?

Thanks!