Anniversary Date Query

HCL Domino Domino Forum
1

Hi All

Is it possible to use something like a wildcard on the year of a date field?

What I would like is to be prompted if an employee’s anniversary of their start date falls within a date range.

For example, if a users start date is 03/05/95, and the date range is 30/04/09;01/05/09;02/05/09;03/05/09;04/05/09 I would like to be prompted that their anniversary is within this range.

Thanks

Jenny

2

Subject: Anniversary Date Query

hi jenny,

why not use @Month or @Day function returns from the anniversary and date range? alternatively, you can change the year of employee’s anniversary date by setting a variable for the anniversary + range’s year then compare it with the range.

hth

leo

3

Subject: RE: Anniversary Date Query

Hi Leo

Thanks for the suggestions. I’ll give them a try.

I appreciate you help.

Jenny