Date Formula.

[g33kgrrl]

I know this should be easy, but I must be brain-dead today.

I need to find all of my employees who are at least 70 years old as of 6/1/2007. This is the formula I am using in my selection criteria:

{PAEMPLOYEE.BIRTHDATE} < {?effective date} - 70

It is not working. Thanks for your help.

 

[Turkbear]

Hi,
What database?


Usually date math is done in Days.

Try ( this works for Oracle DATE types):

({?effective_date}-{HR_CUR_RPTNG.BIRTH_DT})/365.25 > 70.0

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[g33kgrrl]

Yep - I was using Oracle and this worked perfect. Thanks so much!!