Based on Customproperty value Enddate need to trigger disable account task

[ARNAB86]

Hi Team,

I have an requirement that for User attribute lets CP 10 we will update the value in CP10 as End Date (20-07-2024) as an example.

Now using user update rule if i want to disable the account if CP10 is updated and CP10 value matches the current date then the corresponding AD account will be disabled

How to put the query in condition checking (What is the query)

Thanks

Arnab Pal

[naveenss]

Hi @ARNAB86 use the condition like below. Use Advanced config under user update rules. 

(##a.customproperty10 isupdated##) AND (a.customproperty10=curdate())

[Raghu]

@ARNAB86  Requirment for UI update or Import update ?

you need select proper type Trigger Actions when,as per screenshot and you can write below approch also it work,

[ARNAB86]

This is UI update and also will it accept in this format and validate with currentdate

CP10 = 12-07-204

Thanks

Arnab Pal

[naveenss]

@ARNAB86 Use DATE_FORMAT(curdate(), '%d-%m-%Y')

[Raghu]

@ARNAB86  you can try below @naveenss  provided date format if not work use below try

DATE_FORMAT(curdate(), '%m-%d-%Y')

[rushikeshvartak · Accepted solution]

(##a.customproperty10 isupdated##) AND (a.customproperty10=DATE_FORMAT(curdate(), '%d-%m-%Y'))