Convert a timestamp field from double to date/time

Help me!
1

Hello,

In my database, I have a field with timestamp information stored in double.

I could create a summary page where this information is shown. But I couldn’t fine any way to change the presentation format from double to timestamp, so in the table the value is shown in a date-time fashion, instead of a double number.

Is it possible to perform this conversion in UI? How is the correct approach to address this problem?

Best regards,

Flavio

2

Hi @Flavio_Alves,

Sadly right now you can’t convert in the UI a double into timestamp.
But you can do it with smart field, you just need to create a smart field that convert you double into date for example.

collection({
  fields: [{
    field: 'myDateSmart',
    type: 'Date',
    get(record) {
      return new Date(record.myDoubleValue);
    },
  }],
})