Convert epoch to human readable date

[Joon]

Hello All,

I am trying to import users with some attributes that formatted by epoch.

I tried some approaches found here in the forum but none of them seem to work.

our version is 5.5sp3, Could I have any advice ?

below are what i have tried

- "CREATED_ON":"new java.text.SimpleDateFormat('yyyy-mm-dd').parse(new java.time.Instant().ofEpochMilli(createdAt))~#~date"

-"CREATED_ON":"createdAt~#~epochdate",

-customproperty7":"createdAt~#~millisec

[rushikeshvartak]

Which connector ?

• "customproperty2": "createdate~#~epochdate"

[Joon]

using REST connection...

got this data from the target application and would like to import them to create_on and update date with readable date.

[rushikeshvartak]

"customproperty2": "createdAt~#~epochdate"

Try above and let me know results

[Joon]

Hello,

the epoch data that I got from the target app is "1550732635000"

this is what i got below with your code which is supposed to be presented "2019-02-21 07:03:55"

[rushikeshvartak]

What about millisec

[Joon]

Yes, millisec is same as epochdate.

[Joon]

[Joon]

I got confirmed that "epochdate" won't be working for lower than the latest sp3 from Freshdesk....

[rushikeshvartak]

Check with them if they can backport or nor