Date Format

Status: Closed · Asked by lelehelloworld on · 0 views

lelehelloworld — Question ·

i have a work flow from Xero to Google Sheet.
But the date show in the sheet as like below, how should I format this?

Himesh Soni — Reply ·

You can use Date/Time Formatter before you are entering your data to Googlesheet


If you are still not able to solve this on your own feel free to DM me and we can do a free zoom call. FYI I'm not from Pabbly Connect team, just a freelancer you helps other Pabbly users.

Automation Freelancer
Contact me - https://www.facebook.com/himeshsoni07
Email - [EMAIL][email hidden][/EMAIL]
lelehelloworld — Reply ·
You can use Date/Time Formatter before you are entering your data to Googlesheet


If you are still not able to solve this on your own feel free to DM me and we can do a free zoom call. FYI I'm not from Pabbly Connect team, just a freelancer you helps other Pabbly users.

I've added the Date/Time Formatter before the google sheet action, but still doesn't work.
My workflow now: Xero -> Delay by Pabbly -> Date/Time Formatter -> Google Sheet


Himesh Soni — Reply ·

In From Date field you are passing the wrong format. Put the format in which you are getting updated date.

Automation Freelancer
Contact me - https://www.facebook.com/himeshsoni07
Email - [EMAIL][email hidden][/EMAIL]

Back to all forum threads · Log in to reply