Collar Attributes
The Attributes you specify on the Collar Attributes tab can be used when you want to group or classify drillholes using some non-unique identifier. This can be useful when specifying a filter, for example, to limit the display to those holes within a particular survey section.
Note that the fields defined on the New tab (of the Database Properties form) are treated as per the file structure; however, the fields on the Collar Attributes tab will always be treated as Character (or Strings) by a filter expression, regardless of the source field type.
In particular, DATE functions used in expressions will require date strings to be converted to DATES using the TODATE() function. The safest way to do this is to specify the date format as a parameter to that function.
If a date format specifier is not supplied, for example, you use:
=TODATE([str])
the function will try to parse it, but the results may be unexpected. It is recommended to always provide a second argument which specifies the date format. For example:
=TODATE([str],"yyyy/MM/dd")
