Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

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
Valued Contributor II
Valued 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 you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.