Hi,
I'm currently building a front end database web app w/ VS2013 and MySQL 5.6.
I'm trying to set up a query that brings up all hardware purchased within certain dates where it checks the current date, subtracts a year, and pulls up all hardware purchased within that time frame.
Formerly in an old MS Access database, the query string was set up within ((tblHardware.PurDate)<Now()-365) and it worked fine, but SQL server doesn't play nice with that.
It will almost always bring up an error regarding the requirement of a to_date function or having an sql syntax error with mysql. (using date_add and curdate)
Any suggestions?
Thanks