Trench Attributes
The Attributes you specify on the Trench Attributes tab can be used when you want to group or classify trenches using some non-unique identifier. This can be useful when specifying a filter, for example, to limit the display to those trenches within a particular survey section.
Note that the fields defined on the New (Trench Database) tab (of the Database Properties form) are treated as per the file structure; however, the fields on the Trench 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")
