I need a report on Employee Hires in a given interval (between 1/1/2008 - 12/31/2008). Therefore, I pass the time interval to the query. However, I need master data as of the Hire Date of the Employee. What type of variable should I pass in the query properties (as key date) so that it reads employee hire date during query runtime?
Just FYI...Hire Date is a characteristic and displays on the report. Different employees could be hired on different days in a given time interval.
Best Regards,
-Sonny
Edited by: Sonny Mohnalkar on Jun 9, 2009 7:23 AM
Edited by: Sonny Mohnalkar on Jun 9, 2009 7:24 AM