Stripe date format converter
Status: Closed · Asked by Tamosukas on · 0 views
Hello, I connected stripe to sheets https://connect.pabbly.com/workflow/mapping/IjE4MjM3MSI_3D
and want to add date from stripe, but they providing time in UNIX Timestamp.
Question how to add date and time when entry is creted? Wtith Date/Time Formatter by Pabbly i getting only numbers maybe becasue i chosed Include Time in Response false? Now I changed it to tru and will check, but untill that, question how to conwer UNIX time stam and enter to a sheet
You can try something like this to convert UNIX Timestamp -
I getting strange responce 
It should be captial X as shown below -
We have updated your workflow as well. Please check it.
hi i tried this but got wrong value
Attachments
capital X worked, thanks