conditional formatting for birthday date
From: bart van deun (vdb_at_pandora.be)
Date: 01/30/05
- Next message: Douglas J. Steele: "Re: Better Way to Delete Import Error Tables?"
- Previous message: Bill Sturdevant: "Better Way to Delete Import Error Tables?"
- Next in thread: Marshall Barton: "Re: conditional formatting for birthday date"
- Reply: Marshall Barton: "Re: conditional formatting for birthday date"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 30 Jan 2005 15:38:07 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
- Next message: Douglas J. Steele: "Re: Better Way to Delete Import Error Tables?"
- Previous message: Bill Sturdevant: "Better Way to Delete Import Error Tables?"
- Next in thread: Marshall Barton: "Re: conditional formatting for birthday date"
- Reply: Marshall Barton: "Re: conditional formatting for birthday date"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|