Tenure - Dervied Field

[salbrandt]

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

 

[CharlesCook]

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

http://CharlesCook.com

Specializing in ReportSmith Training and Consulting

 

[salbrandt]

I think we're SQL.

 

[CharlesCook]

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.

http://CharlesCook.com

Specializing in ReportSmith Training and Consulting

 

[salbrandt]

I'm told it's Oracle.

 

[CharlesCook]

I'm getting an error saying the DATEDIF is not valid.

For example there is no DATEDIFF function in Oracle.

I'm told it's Oracle.

I think we will need to start from the beginning. Define Tenure. Is it Current Date -

hire/rehire date (whichever is greater of those two dates).

What unit of measure (days or months or years).

http://CharlesCook.com

Specializing in ReportSmith Training and Consulting