AnsweredAssumed Answered

Attribute Sync: transform to date type

Question asked by Bilal Essa on Jan 26, 2017
Latest reply on Jan 27, 2017 by Bilal Essa

We currently have a field from the HR Identity feed that indicates 'Last working Day', and would like to sync to AD (accountExpires) when this is updated.

 

Account custom attribute: "Expiry Date"

User custom attribute: "Last working day"

 

The account is populated by an AD collector, and the user by a database collector.

Both custom attributes are Date type.

 

Have setup the attribute sync as follows:

(using the transform in #1, and not in #2)

Attribue Sync config

 

1: I have tried using the transform to convert the date to the required format:

Date Transform

though am still receving the following error message:

"Unparseable date: "04-MAY-17". Value of 'accountExpires should be in 'MM/dd/yy HH:mm a' format

 The AFX connector (Active Directory) 'Update an Account' capability has

accountExpires as a parameter and is mapped to ${Account.Expiry.Date}

 

2: I have also tried converting the date in a SQL node on the Workflow:

Has removed the transform on the sync, and used the following query:

"Select distinct

to_char(usr.cus_attr_user_cad_1, 'MM/dd/yy HH12:mi am') as AFXCUSTOM_expiry_date_test

FROM t_master_enterprise_users usr join t_av_user_account_mappings map

on usr.id=map.user_id join t_av_accounts acc on map.account_id=acc.id

where account_id='${access_request_cri_acc_id}'

"

The AFX connector (AD) 'Update an account' capability has

accountExpires mapped to ${Expiry_Date_Test},

and mapped ${Account.Expiry_Date} to a random AD field since it is required.

 

I am still receiving error message:

Unparseable date: "${Expiry_Date_Test}". Value should be in ...... (as above)

 

 

Any ideas?

Outcomes