how to highlight the (date) object in form when birthday (last 14 days before birthday)

[bart van deun]

Hello everybody,

i want to highlight the date object in my form the last 14 days before a
birthday in red,

i do this with the conditional option for an object in a form.

Now i have those 3 possibilities but nether is working well, can somebody
help me please? Thank you..

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

or

DateDiff("d";Date();IIf(Format([KLANTverjaardagdatum];"mmdd")<Format(Date();"mmdd");DateSerial(Year(Date())+1;DatePart("m";[KLANTverjaardagdatum]);DatePart("d";[KLANTverjaardagdatum]));DateSerial(Year(Date());DatePart("m";[KLANTverjaardagdatum]);DatePart("d";[KLKLANTverjaardagdatum]))))

or

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



Bart

 

[Guest]

Is KLANTverjaardagdatum a date field? If so, can't you
just use this?

DateDiff("d",Date(),[KLANTverjaardagdatum]) Between 0 And
14

-----Original Message-----
Hello everybody,

i want to highlight the date object in my form the last 14 days before a
birthday in red,

i do this with the conditional option for an object in a form.

Now i have those 3 possibilities but nether is working well, can somebody
help me please? Thank you..

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

or

DateDiff("d";Date();IIf(Format ([KLANTverjaardagdatum];"mmdd")<Format(Date
();"mmdd");DateSerial(Year(Date())+1;DatePart("m";
[KLANTverjaardagdatum]);DatePart("d";
[KLANTverjaardagdatum]));DateSerial(Year(Date());DatePart
("m";[KLANTverjaardagdatum]);DatePart("d";
[KLKLANTverjaardagdatum]))))

or

Format(Date(); "mmdd") Between Format

(KLANTverjaardagdatum;"mmdd") AND