Thanks all. Spencer, I had used your format before writing to the list -- but without the quotation marks!! It is amazing what those little things can do! Thanks much, that did the trick. I also had a strange occurrence on the geocode of this dataset. Somewhere in the process I ended up with some duplicates. Don't ask me how, but somewhere between the original file and the initial geocode with MapMarker and then the "corrections" with the ADOT street data (the only way I can get the students accurately placed after MapMarker has given me good Outaddresses) I ended up with duplicates not in my original file. Has anybody else experienced this? I have been geocoding students using this method for almost a year and this is the first time I have experienced this. Again, thanks for the help on the date query - worked perfectly. Fran Peck Peoria Unified School District 6330 W. Thunderbird Rd. Glendale, AZ 85304 623-486-6099 fax: 623-486-6111 [EMAIL PROTECTED] -----Original Message----- From: Spencer Chainey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 02, 1999 1:41 AM To: Fran Peck; [EMAIL PROTECTED] Subject: Re: MI Date Query 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] ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
