How to set {$SYSDATE()$} into Effective Date on Scheduled Extract ?

Summary:

How to set {$SYSDATE()$} into Effective Date on Scheduled Extract ?

Content (please ensure you mask any confidential information):

How to set {$SYSDATE()$} into Effective Date on Scheduled Extract ?

I believe in past scheduled extract, the Effective Date was showing up as being set to new date

not hard-coded.

My baseline date is being used and 'New Hires' are not being picked up by the extract output and reports

Root Data Group filter (asg.assignment_type='E') 

Version (include the version you are using, if applicable):

24a

Code Snippet (add any code snippets that support your topic, if applicable):