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!

Tenure - Dervied Field

Status
Not open for further replies.

salbrandt

Technical User
Apr 21, 2010
3
US
I'm trying ot use information from other posts to create a derived field for Tenure and I'm getting an error saying the DATEDIF is not valid. Can someone assist? I just want to know tenure based on hire/rehire date (whichever is greater of those two dates).

Thanks!

Using ReportSmith 3.10

Shane
 
What Brand (Oracle, SQLServer...) database are you using ? For example there is no DATEDIFF function in Oracle. Also could you post your formula.

Specializing in ReportSmith Training and Consulting
 
Hi,

SQL is not the brand. SQL is like minivan or pickup or SUV (type). Oracle is like Ford or Chevy or Dodge (Brand).

I need to know the brand as the SQL syntax is brand specific. For example Oracle syntax it different from SQL Server and Gupta etc.

Specializing in ReportSmith Training and Consulting
 
salbrandt said:
I'm getting an error saying the DATEDIF is not valid.
CharlesCook said:
For example there is no DATEDIFF function in Oracle.
salbrandt said:
I'm told it's Oracle.
I think we will need to start from the beginning. Define Tenure. Is it Current Date -
salbrandt said:
hire/rehire date (whichever is greater of those two dates).
What unit of measure (days or months or years).

Specializing in ReportSmith Training and Consulting
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top