Spreadsheet Date Issue

saica · October 13, 2023, 1:46pm

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!

EmeraldHerald · October 13, 2023, 3:35pm

Hi @saica

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

saica · October 16, 2023, 1:24pm

Thanks. Hopefully an answer is found!

saica · October 23, 2023, 5:43pm

Any luck with this?

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

EmeraldHerald · October 24, 2023, 8:58am

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

jan · November 15, 2023, 2:46pm

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

system · February 13, 2024, 2:47pm

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