Never mind, figured it out!
-----Original Message-----
From: [EMAIL PROTECTED] on behalf of Ronning, Christine
Sent: Tue 7/4/2006 12:16 PM
To: MapInfo-L@lists.directionsmag.com
Subject: [MI-L] Selecting Dates
Hi everyone,
I'm trying to select dates from a table and keep getting the "Could not Convert Data" error message and I have no idea why!
I've used the following in the SQL Select Box:
Select Columns: *
from Tables: tmep
where condition: Dat_of_Shift="14-06-2006"
When I use the verify button it comes up with the "Syntax is Correct" message
Can anyone help me with why it won't select records with the requested date? Thanks
Christine
_______________________________________________ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l