what would be the syntax for making a query of all futures hires?
I'm using the following syntax, but since future hires are filtered automatically (because their record start date is in the future, so they don't exist at query time) I see no results.
what am I missing?
Thanks in advance.
ps. - ok i managed to find related posts regarding the issue. setting the prefix SET VARIABLE PARAM_EFFECTIVE_DATE='2050-12-31'; will do the job but it will apply it for all the fields in the query. is there a way to apply it for a specific field? (all other fields on the same report should be taken on current date)