How To Filter Drillholes By Date In DD/MM/YYYY Format

If the date column in your collar file is in DD/MM/YYYY format (or something similar), it will most likely be written as a Character field type (Figure 1).

Figure 1: Collar file in the Modify Structure form showing the date field and corresponding field type.

Trying to apply a filter on this field will yield some undesirable results; this is because Micromine sees this as a string of characters, and isn't able to read the numeric values. In order to filter holes by date correctly, your date column either needs to be in long format as integer data (e.g. 19930322) or as the Date field type in your DAT file (Figure 2).

Figure 2: Collar file in the Modify Structure form after changing field type to Date.

Opening the Modify Structure form and changing the field type to Date will automatically reformat your date column into a YYYY-MM-DD format. After refreshing your drillhole database (Drillhole | Database | Refresh), you can now filter your drillholes by date. Note: you must write the values in the exact same format (Figure 3) and have your date column selected in the Collar Attributes of your drillhole database (Figure 4).

Figure 3: Drillhole Database Filter Setup with an example filter. This filter will include any holes drilled on or after 23/12/1993.

Figure 4: Drillhole Database form with the Date column of your collar file selected as a Collar Attribute.

Want to learn more?

Online Help Manuals - Click here for the latest version

Learning Management System - Click here to login or here to request access