Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 3 of 3

MapInfo Pro 9.5 - Search between 2 dates?

This is a discussion on MapInfo Pro 9.5 - Search between 2 dates? within the Other Mapping Platforms forums, part of the Map Forums category; Hi all. My first posting here, but probably not the last. Hello to you all from the UK. I use ...

  1. #1
    MikeB is offline Junior Member White Belt
    Join Date
    Nov 2008
    Posts
    2

    MapInfo Pro 9.5 - Search between 2 dates?

    Hi all.

    My first posting here, but probably not the last. Hello to you all from the UK.

    I use MIP to trace graffiti crime. I have a table with 2 years worth of records, but I want to cut out just a portion of this, by date range.

    Can someone please point me to an example of a query that will do this? On Googling I found recourse to the "Between" function but I can't find it in the MapInfo QUERY / SQL select / Functions dropdown box.

    Any help would be gratefully recieved.

    Mike.
    Last edited by MikeB; 11-27-2008 at 10:55 AM.

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: MapInfo Pro 9.5 - Search between 2 dates?

    I just did this the day before yesterday ! Although I am using MapInfo 8.5, it's the same thing.

    Simply use AND... so it would be like

    date > 1/1/2006 and date < 12/312006

    to get all the records from 2006.

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  3. #3
    MikeB is offline Junior Member White Belt
    Join Date
    Nov 2008
    Posts
    2

    Re: MapInfo Pro 9.5 - Search between 2 dates?

    Hi and thanks.

    I've been advised to try this by someone who does other databases but I haven't tried it yet. It won't be long until I do though!

    dtPictureTaken>="25/4/2007 13:10:99.999" AND
    dtPictureTaken<="26/4/2007 13:10:00.000"

    I'm sure I could get away with the seconds though.
    Last edited by MikeB; 11-28-2008 at 09:15 AM. Reason: Missed out the quotes.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. MapInfo
    By jorgebec in forum Other Mapping Platforms
    Replies: 0
    Last Post: 11-25-2008, 09:07 AM
  2. Adding Live Search Maps As An Internet Explorer Search Provider
    By VirtualEarth MSDN Blog in forum Bing Maps Blogs & Tweets
    Replies: 0
    Last Post: 09-21-2008, 06:52 AM
  3. Live Search Instant Answers Clicks-Thru to Live Search Maps China
    By VirtualEarth MSDN Blog in forum Bing Maps Blogs & Tweets
    Replies: 0
    Last Post: 12-13-2007, 02:40 PM
  4. How to associated dates with waypoints in MapPoint.
    By mayorfunk in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 04-26-2005, 12:33 PM
  5. Data Import Bug - MapPoint imports Numbers as Dates
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 07-23-2003, 08:50 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96