User Import-Enddate Conversion issue

[PuspanjaliM]

Hi Team,

Our HR system is sending values in dd/mm/YYYY (10/03/2023) format.

we want to store that value on enddate.

During import this error we are receiving error

"COMPUTEDCOLUMNS":["displayname","STATUSKEY","manager","customproperty36","customproperty37","customproperty41","customproperty42","customproperty39","customproperty40","customproperty23","customproperty1","customproperty2","customproperty31","customproperty5","employeeType","customproperty47","customproperty46","customproperty45","customproperty51","customproperty52","customproperty49","customproperty53","customproperty54","customproperty56","enddate"],"PREPROCESSQUERIES" : [ "UPDATE NEWUSERDATA SET NEWUSERDATA.customproperty1 = NEWUSERDATA.customproperty11 where (NEWUSERDATA.customproperty1 is null OR NEWUSERDATA.customproperty1 = '')","UPDATE NEWUSERDATA SET NEWUSERDATA.employeeType = NEWUSERDATA.customproperty33 where (NEWUSERDATA.employeeType is null OR NEWUSERDATA.employeeType = '')", "UPDATE NEWUSERDATA SET NEWUSERDATA.customproperty5 = NEWUSERDATA.customproperty19 where (NEWUSERDATA.customproperty5 is null OR NEWUSERDATA.customproperty5 = '')", "UPDATE NEWUSERDATA SET NEWUSERDATA.customproperty31 = NEWUSERDATA.customproperty26 where (NEWUSERDATA.customproperty31 is null OR NEWUSERDATA.customproperty31 = '')", "UPDATE NEWUSERDATA SET NEWUSERDATA.customproperty2 = NEWUSERDATA.customproperty12 where (NEWUSERDATA.customproperty2 is null OR NEWUSERDATA.customproperty2 = '')","UPDATE NEWUSERDATA SET NEWUSERDATA.customproperty23 = NEWUSERDATA.phonenumber where NEWUSERDATA.phonenumber is not null","UPDATE NEWUSERDATA SET displayName = CONCAT(lastname,', ',firstname) where (displayName is null or displayName='')","UPDATE NEWUSERDATA SET NEWUSERDATA.enddate = DATE_FORMAT(STR_TO_DATE(NEWUSERDATA.enddate, '%d/%m/%Y'),'%Y-%m-%d') where NEWUSERDATA.enddate is not null and NEWUSERDATA.enddate !=''","UPDATE NEWUSERDATA LEFT JOIN CURRENTUSERS ON NEWUSERDATA.employeeid = CURRENTUSERS.employeeid SET NEWUS

I used this post reference. But somehow suggested solution not working for me

https://forums.saviynt.com/t5/identity-governance/date-conversion-from-dd-mm-yyyy-to-mm-dd-yyyy-in-p...

[CR · Accepted solution]

you can try format as same

Any way it take default yyyy/mm/dd , you can pass directly your value alone and try it

UPDATE NEWUSERDATA SET NEWUSERDATA.enddate = DATE_FORMAT(STR_TO_DATE(NEWUSERDATA.enddate, '%d/%m/%Y')) where NEWUSERDATA.enddate is not null and NEWUSERDATA.enddate !=''","UPDATE

[PuspanjaliM]

Hi Raghu,

Thanks for the suggestion , it has worked.

This is  the updated query

,"UPDATE NEWUSERDATA SET NEWUSERDATA.enddate = DATE_FORMAT(STR_TO_DATE(NEWUSERDATA.enddate, '%d/%m/%Y'),'%m/%d/%Y') where NEWUSERDATA.enddate is not null and NEWUSERDATA.enddate !=''",