Select a query using dates from a database in MS Access
8 次查看(过去 30 天)
显示 更早的评论
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?
回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!