• 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

Date/Time Formatter missing format

Not open for further replies.
I need to convert this - 2021-09-28T08:52:17.436Z - which is pulled in from Google My Business, to this - 28/09/2021 08:52:17 - before importing into Google sheets. This format is missing from the Date/Time Formatter - it only has "DD/MM/YYYY hh:mm:ss A" and I do not want the AM/PM adding, as this isn't recognised by default in my sheet (that has existing dates in it).

Is there a reason why this format is missing, and how can I convert to the required format?

Thanks in advance.


Well-known member
Staff member
Hey @searchdusoleil

You can use the Date/Time Formatter's Format Date with TimeZone to convert into your desired format.

Not open for further replies.