Stripe date format converter

[Tamosukas]

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

 

[Pabbly]

You can try something like this to convert UNIX Timestamp -

 

[Tamosukas]

I getting strange responce

 

[Pabbly]

It should be captial X as shown below -

We have updated your workflow as well. Please check it.

 

[msaharan29]

hi i tried this but got wrong value

 

[msaharan29]

capital X worked, thanks