How to convert epoch datetime to appian date and time format?

Question

How to convert epoch datetime (unix date time) to appian date and time format? 
 Eg. 1533622850 - This is in epoch date time, which is a LONG. Now if we convert it to appian date time format "yyyy-MM-dd'T'HH:mm:ss", we are getting date out of range error while using datevalue() function. Please suggest suitable way out. 
 
 If I have to create a plug-in in java for this, what would be the procedure? Can anyone state the steps to create java plug-in and use it in appian?

dmitryg · Accepted Answer

Hi Sudiptab, 
maybe you can use functions docs.appian.com/.../fnc_date_and_time_datetime.html and docs.appian.com/.../fnc_scripting_datetext.html 
Example : datetext(datetime(1970, 01, 01, 0, 0, 0) + 1534147522/86400,"yyyy-MM-dd'T'HH:mm:ss") 
Test Output "2018-08-13T08:05:22"

Krishna Chaitanya · Answer

Hi Sudiptab, UnixDateConverter.zip 
 I have created a plugin for this requirement 
 or use this code 
 todatetime( datetext( datetime( 1970, 01, 01, 0, 0, 0 ) + 1534147522 / 86400, "MM/dd/yyyy HH:mm a" ) )

How to convert epoch datetime to appian date and time format?

Top Replies