I need help creating a calculated field that combines an epoch time (text) column and a date (date) column into a "YYYY-MM-DD HH:mm " format, displaying data by the latest timestamp

Q&A
, , ,
1

Hi Team,

I have an epoch time column with a text datatype and a date column with a date datatype. I want to create a calculated field that combines these two columns and displays the result in the "YYYY-MM-DD HH:mm

" format. Furthermore, I need to show the data sorted by the latest timestamp. Could someone please guide me on how to achieve this?

Thank you!

2

Hello @isingla !

Could your clarify why you need to combine the two fields? If they represent the same date in your data across the row you should be use formatDate on one of the date fields.

3

Hey @duncan, I’m looking to display my data based on the latest eventtimestamp, which is stored in epoch format as text. Could you guide me on how to achieve this?

4

Hello @isingla !

You can use the epochDate function to convert the date into a readable format:

You can then use max of maxOver on that calculation to get the max date. One thing to note, if you just use max you will only get the max date according to any filtering you applied. You can use maxOver to get the absolute max date of your dataset:

Max Date = max({Order Date})
Max Over = maxOver({Order Date}, [], PRE_FILTER)

image