Date Format

[lelehelloworld]

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]

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.

 

[lelehelloworld]

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

View attachment 34135
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]

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