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!

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

Date Comparison with Derived fields???

Status
Not open for further replies.
abowling

abowling

Technical User
Apr 27, 2005
33
US
I am needing a derived field to do the following:

If Termination Date < 01-JUN0-2005, then make term date null, otherwise, list the term date

any suggestions?
 
Sort by date Sort by votes
What Database are you using?

CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

lmackin
  • Locked
  • Question
Job Code History date
Replies
0
Views
611
lmackin
lmackin
SamD1996
  • Locked
  • Question
Derived Fields and Detail
Replies
0
Views
554
SamD1996
SamD1996
amandacody
  • Locked
  • Question
Can I please get help with a DECODE function that contains a derived
Replies
0
Views
547
amandacody
amandacody
tdistaso
  • Locked
  • Question
Saving to Excel 2010 with ReportSmith V3.12
Replies
0
Views
540
tdistaso
tdistaso
mjteaches
  • Locked
  • Question
ReportSmith How to Add Date
Replies
0
Views
536
mjteaches
mjteaches

Part and Inventory Search

Sponsor

Back
Top