After Update sort is not working with date values

[peda]

Before we make update all date colums was as string in Stimulsoft and date Sorting was working.

After Update date colum is also string but now it sorting like a realy string.
So we must edit all reports to change date colum from string to datetime.

Is it a easier way to do this ?

Thanks for help

Best regards Peter

[Lech Kulikowski]

Hello Peter,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.

[peda]

Hi Lech

Its simple to reproduces the issue.
We have in Datatables a field named "date" (its realy a date field but in all reports its a string datatype)

When i have a datatable and make sorting by date (datatyp = string) sorting = wrong
When i habe a datatable and make sorting by date (datatyp = datetime) sorting = working

In older Versions it was working correct and also when datatyp = string sorting correct. I think it automaticly checked its a datetime datatype.
In new Version it use this as string and sorting is wrong.

The Solution is to change all Reports with field date from string to datetime. But we habe so many reports so it will be very difficult to change all reports.

Sorting date as datetime = correct:
2024-04-28
2024-04-29
2024-04-30
2024-05-01
2024-05-02
Sorting date as string = wrong
2024-05-01
2024-05-02
2024-04-28
2024-04-29
2024-04-30

Perhaps is a solution, so we don't change all Reports.

Thanks Peter

[Lech Kulikowski]

Hello Peter,

We couldn't reproduce the issue on our test data.
Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.