I have studing you reportcontrol sample, but cant figure out how the control trying to sort the dates columns .... maybe it is because my windows use the date format dd-mm-yyyy (danish), that sample just does't sort the dates columns in a right way....

anybody have a small small samples that can sort a date column correctly.... (is has to work with at data and a time)

Kind regards

Jens

One solution I've found is to populate the SortPriority with the numeric value of the date e.g.   

If IsDate(val)
    Item.Value = Format(val, "ddd dd/mm/yyyy")
    Item.SortPriority = val
Else
    Item.Value = val
End if

Another solution, which Maui found (see https://forum.codejock.com/forum_posts.asp?TID=1119&PN=1#2921 - https://forum.codejock.com/forum_posts.asp?TID=1119& PN=1#2921 ) is to set the Value to the date/number, then set the caption to the formatted value, which leaves the sortpriority free to be used as intended.

e.g.

Item.Value = val
If IsDate(Item.Value)
    Item.Caption = Format(val, "ddd dd/mm/yyyy")
ElseIf IsNumeric(Item.Value)
    Item.Caption = Format(val, "#,##0.00")
Else
    Item.Caption = Item.Value
End if