Eternally Functional Expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report with four fields - one field for each quarter of the year.
Each field uses the following expressions to change its contents from white
text to black text after the first day of the quarter has arrived.

Field1 (Quarter 1): Now()>=#2/1/2006#
Field2 (Quarter 2): Now()>=#51/1/2006#
Field3 (Quarter 3): Now()>=#8/1/2006#
Field4 (Quarter 4): Now()>=#11/1/2006#

How can I change this expression so that I don't have to change the date
therein on January 1 of every year?

Many thanks!
GwenH
Some of my best leading men have been dogs and horses ~ Elizabeth Taylor
 
Field1 (Quarter 1): Date()>=DateSerial(Year(Date()),2,1)

Field4 (Quarter 4): Date >=DateSerial(Year(Date()),11,1)

That should be enough for you figure out quarter 2 and 3
 
That did the trick ~ thank you for responding to another one of my
thick-headed posts. I assure you, I'm not quite as thick-headed as I sound in
my posts ... it's just that by the time I write a post, I've been working on
a project so long or I'm so tired that my eyes are crossing and I can't see
an obvious solution.

Thanks again!
 
Back
Top