Hi there - I’ve really been liking what n8n is capable of doing. One hiccup that I’ve run into is that when passing CSV data through the Spreadsheet File node, it is automatically converting all of my date strings into numeric values. Is there a way to override this behavior so that date strings come through as-is? E.g. my input cell contains something like “2019-11-04T06:00:00.000Z” which is coming out of the Spreadsheet File as “43773.25”. Currently I think I’ll have to resort to converting the numbers back to a date string in a later function within my workflow, which works but is a bit clunky. Thanks for any suggestions/ideas!
@cpenner461 Great to hear that you like n8n and welcome to the community! Sorry however that you have problems. I added now the option to read “RAW Data” which will be released with the next version. That should fix your problem.
https://github.com/n8n-io/n8n/commit/a3ad579f89edcd90a9a00bd5f23d5379ba17258f
@jan that looks perfect - thanks for such a quick response!
No problem! Happy if it helps!
Just released [email protected] with the above addition.
Happy new year 2020!
this is just awesome, every question I have so far is answered in the forum. Cool
That is great to hear @crisl! That was one of the main reason why I originally started with a forum rather than with something like Slack. Like that you build organically an amazing database which will provide help for many people for a long time. Compared to Slack where each answer is helpful just exactly 1x and then gets totally lost. Additionally will people find so answers to their questions much faster and saves us a lot of time which we can now use to improve n8n further (that hopefully in the future less forum searches are required )
might be getting of toppic here. but even though I heavily use slack, I NEVER (or ok, only once)
joined a slack group of any open source project and asked questions except I have really a lot of time on my hand didn’t find a different solution.