Date Calculations?

[jgoodman00]

I have a date field, which I plan on coloring according to its relationship with the current date.

If the current date is within 3 months of the specified date it is assigned an orange color.

If the current date is within 1 month of the specified date it is assigned a red color.

How do you test to see whether or not the current date falls within these boundaries?

I am sure it could be done by extracting each part of the date & then testing them individually, but this seems a little long winded when I would have thought this should be quite simple to accomplish in one step.......

James Goodman
j.goodman00@btinternet.com

 

[nickjar2]

How about:

select case DatePart("m", Date) - DatePart("m", txtdate)

case 2
do something

case 3

do something

end select

Nick

 

[nickjar2]

You could place this code on the On_Current event of the form

Nick