Ed-D you need to use "Case" to accomplish that. on the expression tab, click add expression and then Character on the Expression type drop down. The length box should be large enough to hold the text you want, example "new hire". Now, in the expression Text field, add something like the below:

case when Hire-Date between date1 and date2 then 'New Hire'
when Termination-Date between date1 and date2 then 'New Term'
else 'Existing'
end

Click ok when you are done. Again on the Expression page, you need to click on "Use as field" link. This way, the expression will be added to your "Select" fields.

if you look at the "View SQL" page, you should see the expression with your selected fields. Make sure you select hire-date and termination-date fields back as well for the Case to work. Your select should look like:

SELECT hire-DATE, termination-DATE,
       CASE
          WHEN hire - DATE BETWEEN date1 AND date2
             THEN 'New Hire'
          WHEN termination - DATE BETWEEN date1 AND date2
             THEN 'New Term'
          ELSE 'Existing'
       END
  FROM table1;

Awesome!

Thanks very much, Lepa!!!!! You totally ROCK!!!!!

Best Regards,

Ed

(CASE WHEN B.HIRE_DT BETWEEN (:1) AND (:2) THEN ('New Hire') WHEN B.REHIRE_DT BETWEEN (:1) AND (:2) THEN ('New Hire') WHEN B.TERMINATION_DT BETWEEN (:1) AND (:2) THEN ('Termination') ELSE ('Existing') End)

You will have to create prompts for the between dates (:1) and (:2) - make certain to format the prompts as dates.