Hello guys, can someone help me how to transform in quicksight, a numeric field in date format, I want to do the same as the TIME function in Excel. I have a dataset with an hour, a minute and a second column, but it is in numerical format, as in the image, what function should I use to get a date?…

Hi Jesus - no you will need to do calculations in the integer format and then convert it to a string for display. Alternatively you can convert it to a date and just put a generic date as part of it like 1/1/22 HH:MM:SS. Then use the date formatting to remove the date part altogether and only show…

Convert numeric field to date

Question & Answer

Jesus April 26, 2022, 7:42pm 3

yes, this formula in the link, converts it to the format I want, but I can not do calculations

the result is in string format
Is there a way to do the calculation?

1 Like