• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

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

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!
 

Attachments

  • Screenshot 2025-04-30 at 9.56.48 AM.png
    Screenshot 2025-04-30 at 9.56.48 AM.png
    20.8 KB · Views: 4
Top