Question for Bill Wilkinson regarding comparing tw

# Thread: Question for Bill Wilkinson regarding comparing tw

1. Senior Member
Join Date
Dec 1969
Posts
131

## Question for Bill Wilkinson regarding comparing tw

Bill:<BR><BR>Here is the orginal question, your response and my response to your response.<BR><BR>Original Question:<BR><BR>I am trying to create a service announcement page that checks the hire_date of employees, in tblStaff, against the current date and check their length of service to see if it is 3, 5, 10 or 20+ years. Those employees that fall into these service categories get written to the page. I am new to ASP and would appreciate any and all help getting me started.<BR><BR>Thanks.<BR><BR>/////////////<BR><BR>Your response:<BR><BR>...you want the people with *exactly* 3 years of service (but not 4) on a page?<BR><BR>Or even *exactly* 3 years of service, *to the day*?<BR><BR>Or do you mean you want people with &#062;= 3 yrs but &#060; 5 to one page,<BR>with &#062;= 5 but &#060; 10 to another page,<BR>with &#062;= 10 but &#060; 20 to a third,<BR>&#062;= 20 to a fourth?<BR><BR>Or what?<BR>//////////////<BR><BR>My response to you:<BR><BR><BR>It would be exactly 3, 5 and 10 years and 20 or more years that I would be checking for. All employees that meet this criteria would be written to the same page, just on a different row.<BR><BR>The service information is generated for a given month, so I don&#039;t know if it would be easier to check for the service dates &#039;to the date&#039; or &#039;for the month&#039;<BR><BR>I would appreciate your help working through this problem.<BR><BR>Thanks.

2. Senior Member
Join Date
Dec 1969
Posts
96,118

## One more time...

Okay, so to make an example:<BR><BR>In June, you want to see all people who (a) were first hired in June and (b) whose "anniversary" with the company is the 3rd, 5th, 10th, and then *every* anniversary 20 or more?<BR><BR>You say "written to the same page". Do you mean that there would be 4 different Web pages, one for each of those categories? [It&#039;s okay if it&#039;s all one URL, with NEXT and PREVIOUS links, that still counts as 4 pages for this question.] Or are you talking about how the results would get printed?<BR><BR>

3. Senior Member
Join Date
Dec 1969
Posts
131