How can I convert this entry date ID 1745969636 into the ISO 8601 format 2025-04-29T22:57:28.024Z?

[yang_yang74]

How can I convert this entry date ID 1745969636 into the ISO 8601 format 2025-04-29T22:57:28.024Z?

This timestamp comes from a TikTok lead, and I'm trying to convert it using a number formatter (e.g., in Excel, Google Sheets, or another tool). What formula or method should I use to convert this number into a readable date-time format? i want it to appear as ISO 8601 Format once i passed down to the Gsheet as a leads data.

Any help would be appreciated!

 

[Preeti Paryani]

Hello @yang_yang74,

You can use Date/Time Formatter (Pabbly): Format Date Only action to convert the date in timestamp format to a readable format, refer to the attached image for more info.