I need help - I cannot figure out how to use the MySQL node “Select” and filter for a date. If I am using custom query it obviously works - but I am trying to understand what I am doing wrong by using the normal “Select” Method provided by the node.
Describe the problem/error/question
If I select my table and enter a column filter - it says it needs a number.
Hello @Manuel
I don’t have a mysql db, but there might be a couple of options:
Try to set date in the format YYYYMMDD (e.g. 20240506)
Or set it as a timestamp (e.g. 1715194449000)
I don’t think there’s a way to compare non-numeric values with the current MySQL node (although it would be nice to be able to do that, could be a feature request!). It would be the easiest to use custom query for this for now
Thanks for your suggestion - I guess it would solve it, but does not really go with the data type in my DB (which is date). But interesting suggestion.