AD accountImport LastLogon convert it to specific Date format and store to CP

[mbh_it1]

Hello team,

I have following mapping for getting lastlogondate in CP21 as 

CUSTOMPROPERTY21::lastLogon#millisec,

I want to change the value to  "mm-dd-yyyy HH:MM:SS"

Thanks

Mahesh

[rushikeshvartak]

• in AD connector you can't change date format or use string manipulation.
• You can use enhanced query to change date format on accounts another Customproperty

[mbh_it1]

Thanks @rushikeshvartak 

Thanks

Mahesh

[pmahalle]

Hi @mbh_it1 ,

Can you try something like below and check once. It's working for use for user import but not sure for account import

CUSTOMPROPERTY21::lastlogon#Winepoch-customDate

[mbh_it1]

Hi @pmahalle 

It converted to following format, but not as desired

Thanks

Mahesh

[rushikeshvartak]

SELECT
DATE_FORMAT(a.customproperty21, '%m-%d-%Y %H:%i:%s') AS accounts__customproperty22,

acccountkey as accounts__primarykey
FROM
accounts a where endpointkey=1 and status=1;