Livelink ordering by date

Lindy_Baumgartner_(x-lucwireadmin_-_(deleted))

The following SQL Server 7.0 query worked in Livelink 8.1.5. Since upgrading the results are correct number of unique users are represented for the correct day but the ordering of the days, represented by bar chart, does not have the days listed sequentially? Any ideas why the difference between LL 8.1.5 and LL 9.0.0.1SELECT convert(char(10),AuditDate,110) "Audit Date",count(DISTINCT(UserID)) "Number of Users" FROM DAudit WHERE AuditDate <= %2 AND AuditDate >= %1 GROUP BY convert(char(10),AuditDate,110)Thanks,Charlie Guilerguiler@lucent.com