RE: How to select for future event

Alan Shore wrote on 09/11/2006 02:09:09 PM:

I am assuming that you have a file with this data on, and in its 

simplest

form is

Review date
Employee number
Employee last name
Employee first name
Employee middle initial
Employee supervisor.

If Alan is correct, but you want to notify managers automatically of 
impending reviews, you can do something along these lines:

position the file so you don't read any records < 11 months old

for each record;
    if ( %diff( reviewDate + %years(1) : today : *days)  <= 30);
        sendNotice();
    endif;
endfor;

I don't know if using '30 days' instead of '1 month' works for you.  If 
not, it might get a bit complicated.  You will have to decide what one 
month before March 31 is.  Is it February 28?  March 1?  Something else?

HTH,
Adam

#####################################################################################
Attention:
The above message and/or attachment(s) is private and confidential and is 
intended 
only for the people for which it is addressed. If you are not named in the 
address 
fields, ignore the contents and delete all the material. Thank you. Have a nice 
day.

For more information on email virus scanning, security and content
management, please contact administrator@xxxxxxxxxxxx
#####################################################################################