Rehire Advanced Query

[NDY]

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

[Amit_Malik]

can you try this

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