Query Date and Time
For: MapInfo Pro/MapBasic
By: Egge-Jan Pollé
Rated: 5 Stars (1 rating)
The tool Query Date and Time adds 2 functions to MapInfo:
- Select by Date
- Select using Date Functions
Available for both the 32 and 64 bit versions of MapInfo Pro. A new 64 bit versions has been made available. This version integrates itself better into the ribbon interface. Get it here: Query Date and Time x64 only
Select by Date
The function 'Select by Date' offers a dialog to select records by date: before, after or between certain dates (as stored in a Date or DateTime column).
If querying a DateTime column the time can also be taken into consideration.
Select using Date Functions
The function 'Select using Date Functions' offers a dialog to query Date and/or DateTime columns using the following functions:
- Day(): days within a month (1-31)
- Weekday(): days within a week (Sun-Sat)
- Month(): months (Jan-Dec)
- Year(): years
The syntax of the resulting queries will be printed to the Message window, e.g.:
Select * From Calendar Where Date >= "20120828" AND Date <= "20130218" into Last_changes
Select * From Calendar Where Day(Date) in (29) And Month(Date) in (2) into Leap_days
The download, QDateTime.zip, contains 2 zip files:
- QDateTime for MapInfo Pro x64.zip
- QDateTime for MapInfo Professional x86.zip
Choose which one you need to install.
The x64 version is compatible with MapInfo Pro 12.5.1 (64-bit) or higher. To run the tool you will need QDateTime64.MBX, MBExtensions.dll and the img folder with it's content.
The x86 version is compatible with MapInfo Professional 9.5 (32-bit) or higher. To run this version you will need QDateTime.MBX, MBExtensions.dll and DTIcons.dll.
Source code included.
Background information on the C# methods used in this tool can be found here.
A new 64 bit versions has been made available. This version integrates itself better into the ribbon interface. Get it here: Query Date and Time x64 only
File name: QDateTime_1_1.zip
File size: 63KB
File type: zip
Rate & Review
You must be registered and logged in to submit a rating for this entry.