4Site
Support Request System
View Patch #50.038.011
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
03088 -
GST Report - dates not sorted correctly
Symptoms:
Transactions on the GST report were not sorting correctly. For example the transactions would be shown in the following order: Jan 1 Jan 11 Jan 12... Jan 2 Jan 21... Jan 3
Solution:
This problem occurred only with some desktop date formats as configured in Windows. The problem was that the invoice date was being sorted as a string instead of a date which would result in, for example, dates like 11/mm/yy appearing before 2/mm/yy because 11 comes before 2 alphabetically. The solution was to change the report table to define the invoicedate field as a smalldatetime field instead of a string. This causes Crystal report sort the field as a date as intended.
Browse Patches
Find a Patch
Return to Request System Menu
