Just looking for some help here.  I am new to the forum, and would appreciate any advice.

I am looking at creating a report that gives me an 'active snapshot' at any point in time.  So far, I have not been able to do this.  My main problem is that my 'TERMDATE' field is not null, but, instead, all employees that have not been terminated have (1899, 12, 31) as their termdate.

This is the closest I have gotten to a formula.  The date I am going back to for the active snapshot is January 1, 2009.  GLB_STDT is the date the employee started with our organization, and, obviously TERMDATE is the date their employment ended.  To me, the logic makes sense but for some reason it is not working:

if {EMP_MAST.GLB_STDT} > Date (2009,01,01) then false or
if {EMP_MAST.TERMDATE} <= Date (2009,01,01) then false or
if {EMP_MAST.TERMDATE} = Date (1899,12,31) then true

I would appreciate any help with this!

Thank you in advance!


Edited by wpshc - 06 Aug 2010 at 10:44am

IMO I think you are looking for a change in select logic here. You want to be able to enter a date and see what emplyees were 'active' as of that date, correct?

one way would be to create a parameter as a date type and then the select statement would be:

You need to date params, you can name them whatever but I will use 

Thank you very much for your help!  I will be putting it to the test shortly.

It will show them active as of that date entered (and may be termintaed now).

Edited by DBlank - 11 Aug 2010 at 4:41am