Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CASE Derived Field help

Status
Not open for further replies.

abowling

Technical User
Apr 27, 2005
33
0
0
US
Hello,
I am using Reportsmith Version 3.10 I need a derived field to do the following:
Look at the termination date field. If it is less than the hire date then make the field null or ' ' else, list the term date.

I have tried several things like below but can't get anything to work.

CASE "employment.term_dt"
WHEN < "employment.hire_dt"
THEN ' ' (i also tried the 'IS NULL')
Else "employment.term_dt
END
 
case when employment.term_dt < employment.hire_dt then ' '
else employment.term_dt end
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top