Im trying to write a simple SQL statement to retrieve dates after the 1st January 2013. This is written inside a query in ms access:
SELECT * FROM tblWebMeetingData WHERE [Event Date] > 01/01/2013;
This does run but it doesn't get what I want back - it actually gets all records back instead of only getting the one that actually occurs after this date. In the table it's looking at the [Event Date] and its format is mm/dd/yyyy the american format.
Note - that if I place it in quotation marks i.e. "" or '' then it throws an error and determines that there is a data type mismatch. So how should this be constructed?
put the date between ## and in the month-day-year format:
SELECT * FROM tblWebMeetingData WHERE [Event Date] > #01/01/2013#;