We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Convert Date format in REST ImportUserJSON

sppnra
Regular Contributor
Regular Contributor

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

2 REPLIES 2

shivmano
Regular Contributor III
Regular Contributor III

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
Regular Contributor
Regular Contributor

Hi @shivmano ,

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