M
mrburnette
I am trying to search a data set with several columns of dates and pull any
date within a range that I type in for the system to search. A small sample
is below.
I want to set it up so I can search once a month or so for people who are
hitting these anniversary milestones. I want to enter a range of say
07/01/1985-07/31/1985 and pull the name and what anniversary year (ie
1,5,10,15) for anyone in the given data set. Be advised that my actual data
set is much much larger.
HIRE DATE NAME OFFICE 1 YR 5 YR 10 YR 15 YR
10-Apr-79 SHARON RV 4/10/1980 4/10/1984 4/10/1989 4/10/1994
08-Jul-80 PAM RV 7/8/1981 7/8/1985 7/8/1990 7/8/1995
23-Feb-87 HARRIET RV 2/23/1988 2/23/1992 2/23/1997 2/23/2002
13-Jul-87 RON RV 7/13/1988 7/13/1992 7/13/1997 7/13/2002
16-Sep-87 TAMMIE RV 9/16/1988 9/16/1992 9/16/1997 9/16/2002
18-Apr-88 CINDY RV 4/18/1989 4/18/1993 4/18/1998 4/18/2003
23-Jan-89 MONICA RV 1/23/1990 1/23/1994 1/23/1999 1/23/2004
16-Jul-90 JAMES RV 7/16/1991 7/16/1995 7/16/2000 7/16/2005
date within a range that I type in for the system to search. A small sample
is below.
I want to set it up so I can search once a month or so for people who are
hitting these anniversary milestones. I want to enter a range of say
07/01/1985-07/31/1985 and pull the name and what anniversary year (ie
1,5,10,15) for anyone in the given data set. Be advised that my actual data
set is much much larger.
HIRE DATE NAME OFFICE 1 YR 5 YR 10 YR 15 YR
10-Apr-79 SHARON RV 4/10/1980 4/10/1984 4/10/1989 4/10/1994
08-Jul-80 PAM RV 7/8/1981 7/8/1985 7/8/1990 7/8/1995
23-Feb-87 HARRIET RV 2/23/1988 2/23/1992 2/23/1997 2/23/2002
13-Jul-87 RON RV 7/13/1988 7/13/1992 7/13/1997 7/13/2002
16-Sep-87 TAMMIE RV 9/16/1988 9/16/1992 9/16/1997 9/16/2002
18-Apr-88 CINDY RV 4/18/1989 4/18/1993 4/18/1998 4/18/2003
23-Jan-89 MONICA RV 1/23/1990 1/23/1994 1/23/1999 1/23/2004
16-Jul-90 JAMES RV 7/16/1991 7/16/1995 7/16/2000 7/16/2005