Not filter columns type date in Mysql

Questions
1

image
image1293×418 20.5 KB

I made a connection to the MySQL database, and I’m trying to filter one of the columns that is of the Date(Data) type. When I enter a date (Greater or Less) in the input field, it returns an error that the field is not a number. It cannot interpret the input as a date.

Information on your n8n setup

  • **n8n version:latest
  • Database (default: MYSQL):
  • **Running n8n via (Docker):
2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

Welcome to the community @Diego_Marquez :tada:

I think the easiest way to do this at the moment would be to use custom query option and write a query to filter by date.

See a similar post here: MySQL Node - Select -> 'Select Rows' works with numbers

There’s also a feature request: MySQL Node - "Select" ... should be able to filter on date > or <

2 Likes
4

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