Forum Discussion
Solved
get data - load data base on date filter
Hi, I have HUGE table that I load to my model (and workproperly). I want to add line in my sql to load only data the date is greater then 31/12/12 I succeed to do it in excel query but get e...
Hi,
When connecting to MySQL, you can provide a custom SQL statement where you can provide this Date filter.
Alternatively, you could connect to MySQL without a SQL statement, which will let you navigate to the table in question. Once you select the table, click Edit and this will bring you into the Query Editor experience. You can define filters based on Date columns within the Query Editor without the need to learn or write SQl statements. These filters can be static dates or dynamic (i.e. This Week, This Month, Year To Date, etc.).
Thanks,
M.
