Select a query using dates from a database in MS Access
显示 更早的评论
Hello guys!
I have a database in Ms Access with records by dates and I want to import some of the data in matlab choosing a time period. To be more specific, here it's my code! Thank you in advance guys!!
But the data table remains 1x1 and 0. Can you help me?
2 个评论
Geoff Hayes
2018-4-9
Kyriaki - what does dataquery look like? You have two local variables named startdate and enddate but how do you update your data query with these values? I suspect that you want to do
dataquery = sprintf('SELECT * FROM NEWDATA where #%s# < Dates < #%s#', startdate, enddate);
Next is the condition valid for querying between two dates? Don't you need to use BETWEEN instead?
Kyriaki Mylonas
2018-4-9
回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Database Toolbox 的更多信息
2018-4-9
2018-4-9
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
