I can not figure out how to put together a report that shows when an Employee's:
A) 90day Review is due - New hires, based on there hire date (adj_hire_date)

and

B) Annual Review Due - Based off their Adj_Hire_Date

What tables / Fields... thanks, I hope.

Do you want to find those fields in the database or do you want to calculate what the dates would be?

I think I want Field Nbrs 319, 320, 333, also 2089 & 2090 for the review info -But I do need the date field. Also, am trying to put together a totext statement like:

if [field#2089] <> (?not sure of function here) [datestamp] then totext "OVERDUE" else " "

I just am getting confused. Help?

In Crystal Reports 10, use the DateAdd function:

DateAdd("d", -90, {table.fieldname})

will return the date 90 days before the date given in {table.fieldname}.

That's very likely what you want. :coffee:

You need to use the PAemployee table along with the employee table. From the paemployee you can find the next review date .
This is how I would build the overdue statement in formula fields:
If {PAEMPLOYEE.NEXT_REVIEW}< CurrentDate then "OVERDUE" else ""

This would mark as Overdue those employees whose reviews are due in the past. Is this what you were looking for?

You could also use something like that in your select statement and that would only pull those with those dates prior to today.

I am not sure if this is what you want - please feel free to email directly if you would like. I use Crystal quite a bit - not an expert but comfortable with it

Got it to run! You guys rock!

Is this DateAdd not available in Crystal v9

all I have....

What error are you getting?

Nevermind. It worked.