Date/time conversion in GSA

[Robert Lilley (GE)]

Does any one know how to convert EPOCH time in seconds, to standard date and time format?

 

[Frank Pistorius]

Hi Robert,

In case you have a source field called epochSeconds, you could convert this to a date-time using the expression:

Date(1970, 1, 1).AddSeconds(epochSeconds)

In case the epochSeconds value would be something like 1622014566, this expression would result in the date-time 'May 26, 2021 7:36AM'.
Please have a look at the business field's display format for further formatting of the output.

Regards,

Frank