Convert Date format in REST ImportUserJSON

[sppnra]

Hi Saviynt Team,

I am trying to store a date in the CustomProperty37 field using this function

"customproperty37": "employmentNav.endDate~#~epochdate"

But the user is not coming in User update rule

(a.statuskey = '1') AND (a.customproperty37 = (CURDATE() + 1)) AND (a.employeeType != 'Contingent Worker')

Do I have to change the format of the date if yes please tell me what I have to do or do I have to do anything else

[shivmano]

Can you share the value stored in customproperty37? 

Also to increment the curdate() by a day, you can try using DATE_ADD(CURDATE(), INTERVAL 1 DAY)

[sppnra · Accepted solution]

Hi @shivmano ,

Nevermind I figured it out, I have to use the Date_format function in the user update rule, thanks for your response.