Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

Rehire Advanced Query

NDY
New Contributor III
New Contributor III

Hi,

Could you please confirm that this rehire rule looks correct? Rules are not getting triggered even though all the condition matches. The data format is CP17 is string in the form of 8/27/2024.

This rule is to trigger rule for rehire after 30 days:

##a.statuskey isupdated## and a.statuskey =1 and STR_TO_DATE(a.customproperty17, '%m/%d/%Y') < DATE_SUB(curdate(), INTERVAL 30 DAY)

 

Thank you

 

3 REPLIES 3

Amit_Malik
Valued Contributor II
Valued Contributor II

can you try this

##a.statuskey isupdated## and a.statuskey =1 and STR_TO_DATE(a.customproperty17, '%m/%d/%Y') < CURDATE() - INTERVAL 30 DAY

 

Kind Regards,
Amit Malik
If this helped you move forward, please click on the "Kudos" button.
If this answers your query, please select "Accept As Solution".

NDY
New Contributor III
New Contributor III

I tried with the query you provided but the rule still did not get triggered.

Please share screenshot of rule and customproperty17 value screenshot


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.