Conditional formatting with dates..

[Arjan]

Hi All,

Does anybody knows how I can do a conditional format on dates?

i.e. I would like to change the textcolour for every date between 01-xx-xxxx
and 15-xx-xxxx
where the xx stands for every months and the xxxx for every years...

Does anybody have any idea?
thanks in advance!!

Best regards,

Arjan Bregman
the Netherlands

 

[Douglas J. Steele]

Use the Day function to return the day of the month from your date.

 

[Arjan]

Hi Doug,

I'm sorry but I do not understand what you mean..
Could you please clarify it a little bit more?

thnx!

Arjan

 

[Douglas J. Steele]

I can't actually test, because I only have Access 97 installed at the
moment, but where you're setting the condition, based it on
Day([MyDateField]). If that's less than 16, make it colour 1, otherwise make
it colour 2.