Timestamp Format

Queries and Resources
1

Hello again all,

How can I change the timestamp format from 2022-01-11T21:19:57.435Z to MM/DD/YYYY. My value that I currently have is:

#### {{table2.selectedRow.data.Timestamp}}

Thank you!

2

You can change this on the column settings for your table in your account. It will ask you what the data type of the column is and what it should transform that value to on the table.

If you are looking to transform the raw value in a JS query/transformer, the moment() library is built into Retool and you can check out their formatting suggestions here

1 Like
3

Hey @Miotx,

@auste_rich is pointing in the right direction, try something like:

moment(table2.selectedRow.data.Timestamp).format('MM/DD/YYY')
1 Like
4

yes that is the correct approach

1 Like
5

Thank you all, Worked like a charm!

1 Like
6