Date and Time issue

When We read data from Google sheet Date comes in number format how to convert into date so that execution can be done, i have attached google sheet screenshot & N8n Output


1 Like

Hi @chandan988

Have you tried this option?

Issue is same, Date read is in number format

1 Like

Can you share the JSON output?

[

{

“Name”: “chandan”,

“Phone No”: 7838808080,

“Date & Time”: 44832.506944444445,

“From”: “New Delhi”,

“To”: “Patna”,

“Mode of Travel”: “Train”

}

]