I’m exploring Data Tables - super useful addition.
I would like to query rows for a particular range of a date, such a shown below. I’ve tried various outputs for a date and I have rows for the given range however nothing is returned.
In SQL, I’d expect all rows to be returned where date is after the Oct 13th. Is this not supported in n8n or am I missing something?
Hi Lukas, are you able to share the input to this node? If you can see the data on the left side of this node then it should tell you which columns are available
Hi Jack, of course. There isn’t anything more than what’s already visible in this node.
Dates come from Edit Fields (Set) node before which is this
Okay, I found out that if I format the DateTime toUTC() it works. This is rather not intuitive at all as I’d expect timezones to be handled automatically.
Especially given that the timezones do show up in the data table as well. So technically it shouldn’t change anything.
There is no documentation about this on the docs article at all.
I’m glad that you found a solution, and you’re right that the solution is an unexpected one.
Maybe consider using the “helpful” section at the bottom of the relevant docs page and feedback about the unexpected behaviour?
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
