How do i written AD condition in spoon job to get only active users from AD which are modified in last one day.
Now I have written "filter string" is objectclass=user and using validation step to filter active records .
I need to filter records which are active and last modified <sysdate-1 at AD step only and then move the records to next step.
You should be able to use a filter rows step to filter by the date as mentioned.
Sysdate you can get using a @GetsystemInfo step. You can check in pentaho official doc.