I have a node that is trying to modify date formats. I have what I would expect to be correct, but N8N is converting fields without dates into dates… all over the place really. I screenshot really shows the problem with the incoming data and the converted data.
@saica it looks indeed like you’re not looking at the same data here. For some reason it seems like the Date and time node is filtering our rows for you (see input 2980 items, output 317 items). Is that wanted behavior?
The only workaround I have found so far is to write the SpreadSheet file WITH empty cells… which causes the Date//Time to add “Invalid Date” to the field/cell. Then I use a set node to find “Invalid Date” and Replace with nothing.