conditional formatting for birthday date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bart van deun - 30 Jan 2005 15:38 GMT

Hello from Belgium,
i want to highlight the date-part in red in my form between the birthday and
14 day before thate date,
this code(here under) only lights up one day(birthday day) at the time, i
can not find the expression.

Month(Date())=Month([KLANTverjaardagdatum]) And
Day(Date())=Day([KLANTverjaardagdatum])

can anybody help me out?

Thank you!

ps. has to do with between 1 and -14 day before birthday

Reply to this Message

Marshall Barton - 30 Jan 2005 18:07 GMT

>i want to highlight the date-part in red in my form between the birthday and
>14 day before thate date,
[quoted text clipped - 3 lines]
>Month(Date())=Month([KLANTverjaardagdatum]) And
>Day(Date())=Day([KLANTverjaardagdatum])

Try something more like:

Format(Date(), "mmdd") Between Format(KLANTverjaardagdatum,
"mmdd") AND Format(DateAdd("d", -14, KLANTverjaardagdatum),
"mmdd")

Signature

Marsh
MVP [MS Access]

Reply to this Message