Date Format Help

[pawwy1415]

Hi Experts,

Can any one please help me on below issue.

I have extracted the Data from collibra by using Rest API Connector. But Createdon Field showing Text numbers instead of date please help me to convert into Date format.

Thanks in advance.

[Yoshidaqlik]

hi,

You can not see a date in these numbers, it is possible to divide what is year, month, day?

Regards

[sunny_talwar]

May be this

Timestamp(1566436021183 / 86400000+25569)

Conversion from Jullian Date/time stamp to gregorian just date field 

[sunny_talwar · Accepted solution]

Or this

Date(Floor(1566436021183 / 86400000)+25569)