Spreadsheet Date Issue

n8n Cloud.

Attempting to convert a YYYYMMDD string to MM/DD/YYYY with the Date/Time node. However, it outputs incorrectly. Any ideas on how to properly perform this?

Thank you!

Hi @saica :wave:

I just tried this on 1.9.3 and also am seeing this - I’ll report this to our engineers and see if they can find the cause :bowing_man:

1 Like

Thanks. Hopefully an answer is found!

1 Like

Any luck with this?

I ended up resolving it by slicing the date field with the code node.

Hi @saica - first and foremost, I’m glad you found a workaround!

This issue is still in triage with our engineers, I’m afraid, so I wouldn’t have any updates. It’ll be a bit of time before it’s fixed :bowing_man:

New version [email protected] got released which includes the GitHub PR 7675.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.