AnsweredAssumed Answered

How to format epoch date into month day year?

Question asked by Sonoma_Land_Trust on Jul 8, 2016
Latest reply on Jan 17, 2017 by Sonoma_Land_Trust

My concatenation using this formula is working correctly:

concat(${observer}, "-",${species},"-",${date},"-",${time})

 

However the time in epoch format is not friendly to quick review.

 

What formulas or formatting can I use inside this formula to return the epoch value stored in {time} to display in a text box as  "YYYY-MM-DD - H:m:s" -- including any corrections for time zone and or origin in 1970?

Outcomes