Validating a date comparison between attribute value and current date.

[Santosh]

Hello there,

I am working on a user update rule, where I need to trigger a re-hire notification if the user's start date is updated and their original hire date stored on CP11 is within 6 months of current date, I tried few things and stumbled upon a similar query on forum, could you please validate this below,

users.statuskey = 1 AND ##users.startdate isupdated## AND a.customproperty11 +180, <= CURDATE()

[NM]

Hi @Santosh , use this 

a.statuskey = 1 AND ##a.startdate isupdated## AND DATEDIFF(CURDATE(),a.customproperty11)<=180

[Santosh]

tried this on data analyzer, got a syntax error as well on preview on technical rule.

[NM]

@Santosh ,

a.statuskey = 1 AND ##a.startdate isupdated## AND (DATEDIFF(NOW(),a.customproperty11)<=180)

wont't work in data analyzer check in preview of technical rule.

[Santosh]

Getting the 'Invalid condition' on the Technical rule preview mode with above condition.

[rushikeshvartak]

😞

isupdated does not comes in technical rule. You need to use User update rule

[Santosh]

Thank you for the response, I was trying to validate it before pushing it to prod, let me test a rehire scenario on lower environment and see how it goes.