Fran Peck wrote:
>I have a geocoded table of students and I
>want to query out the students who came into the district after Nov 25,
1998
>(data format is 11/25/1998). I have tried a bunch of different ways to ask
>this question (query the data), but continue to get things like "syntax
>error", data mismatch, etc.
I hope this helps.
* First check that the column containing your date information is in 'Date'
format and not character or interger format (Check through
Table/Maintenance). If your date column is not in 'Date' format you should
be able to convert it by simply changing the format type in the Table
maintenance dialog. To be on the safe side, save a back-up copy of your MI
table before carrying out this operation.
* Once date is in 'Date' format you should then be able to perform the
following SQL:
Select *
>From table: mystudentdata
Where: myDateColumn > "11/25/1998"
Into table: Selection
Regards,
Spencer Chainey
Corporate GIS Manager
London Borough of Hackney
[EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
