Date Field Columns May Not Sort Correctly if There is an Identically Named Field That is of a Different Type.

November 13, 2006 | KB: 1011691

https://support.laserfiche.com/kb/1011691/date-field-columns-may-not-sort-correctly-if-there-is-an-identically-named-field-that-is-of-a-different-type-

Laserfiche Server - Team (MSDE) 7.1, Laserfiche Server - United (MS SQL) 7.1, Laserfiche Server - Team (MSDE) 7.2, Laserfiche Server - United (MS SQL) 7.2

Laserfiche allows you to have multiple template fields with the same name as long as they belong to different templates. However, this feature affects how the Laserfiche client will sort date columns if a date-type field shares a name with a non-date-type field.

The Laserfiche client displays all fields with the same name in the same column. When a date-type field and a non-date-type field share the same name, the Laserfiche Server converts the value of the date-type field into a string. This affects how the column will sort since the values will now be sorted alphabetically instead of chronologically.

For a related issue that affected the Laserfiche client (versions prior to 7.1.2), please see the following Laserfiche Knowledge Base article.

1001040 Folder Browser Columns Display Date Field Values With a Time of 12:00 AM.