Setting a date format 1

[techkenny1]

Hi
In our Db there is a continous form that has a start date to show schedules for clients.
The schedules can vary from one month to several months.

What I require is to use condtional formatting so that just the current month can have a different background colour. I know how to set up the condtional formating, but just the code to show the current month.

The date field is "Startdate" which requires the code.
Many thanks

kp

 

[TheAceMan1]

How are ya techkenny1 . . .

For the current month:

[blue]Month([StartDate])=Month(Date())[/blue]

However this could be for any year!

For the current month in the current year:

[blue]Year([StartDate])=Year(Date()) And Month([StartDate])=Month(Date())[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[techkenny1]

Hi the Aceman1
Many thanks for your reply. Had to give u a star for this one.

It works great, but is it possible to be able to modify the code so that the second month using condtional formatting can be set up.
So that the second month entries can have a different condtional formatting?

Thanks,

kp

 

[TheAceMan1]

[blue] ... is it possible to be able to modify the code so that the second month using condtional formatting can be set up.
So that the second month entries can have a different condtional formatting?[/blue]

Not sure what you mean by the [purple]second month?[/purple] [blue]Be more specific![/blue]

In either case ... conditional formatting allows you to setup three conditions.

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]