Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

REST connector accountImport Date format

mbh_it1
New Contributor II
New Contributor II

Hello Team,

 

I want to store effectivestartDate and effectiveendate in CP4,CP5 respectively for account, the format should be  'MM-dd-yyyy'

Now I searched forum as specified below and got similar solution but I am unable to set specific Date format

https://forums.saviynt.com/t5/identity-governance/converting-date-format-in-rest-connector-account-i...

Tried following which store date incorrectly, as I want to convert it to  'MM-dd-yyyy', this is REST connector account Import, please guide

mbh_it1_0-1718372249225.png

 

"globalSettings": {
"dateFormat": "MM-dd-yyyy'T'HH:mm:ss"
}, 

 

Thanks

Mahesh

 

 

3 REPLIES 3

NM
Honored Contributor II
Honored Contributor II

Hi @mbh_it1 , could you also mention the format you are receiving from app end?

mbh_it1
New Contributor II
New Contributor II

Hi @NM 

following is the format I am receiving data if I dont do any formatting and store to CP, it looks as below

mbh_it1_0-1718374639158.png

Thanks

 

#CONST#${new SimpleDateFormat('MM-dd-yyyy').format(new SimpleDateFormat('yyyy-MM-dd\'T\'HH:mm:ss').parse(data.effectiveDate))}~#~char"


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.