I have an Access 2007 Database and I am accessing a table which has an entity (among other entities) named LogDate which is of Date/Time data type. Using SQL, I need to access these log records within a selected date range. At the moment I am doing the comparison as follows:
Select * From LogTable Where CTOD(Mid(LogDate,1,10)) Between SelStart And SelEnd.
I am getting the desired result but I just seem to think there must be a better way of doing this.
I am using VB.Net of Visual Studio 2010 and running under Windows 7.
Is there a better way ?.