Fast Formula - Person Selection

Summary

Need a Person Selection rule for weekly New Hires

Content

Hello!

I am trying to create a person selection rule that selects weekly new hires so we can batch process their benefit events

I found a function that pulls out the week, but it does not seem to be working (and it's not in any of the documentation)

Any help would be great

Thanks!

DEFAULT FOR PER_PERSON_ENTERPRISE_HIRE_DATE IS '1900/01/01 00:00:00'(date)

l_hire_date = PER_PERSON_ENTERPRISE_HIRE_DATE

l_hire_week_of = to_char(l_hire_date,WW)

l_week = to_char(to_date('2017-11-13','yyyy-mm-dd'),WW)