Apply sorting on date column:

[sanakalam]

I want to apply sorting on date column but there is an issue date is also considered as a string and 1st date of all months shown then 2nd date of all month showing.
How can we manage sorting for date column

[ISchwarz23]

Hi @sanakalam,

can you pleas show your comparator for the date column?

Best regards,
Ingo

[sanakalam]

tableView.setColumnComparator(6, new Comparator() {
@OverRide
public int compare(RequestInquiryModel o1, RequestInquiryModel o2) {
return o1.getCreatedOn().compareTo(o2.getCreatedOn());
}
});

[ISchwarz23]

What data type does getCreatedOn() return? String?

[sanakalam]

yeah String. I am fetching data from API and date return as a String

[ISchwarz23]

I would suggest to transform the string to date using SimpleDateFormat.

[sanakalam]

SimpleTableDataColumnAdapter c7 = new SimpleTableDataColumnAdapter<>((SimpleTableDataColumnAdapter.StringValueExtractor) data -> data.getCreatedOn().toString());

For Date which method we have to use instead of StringValueExtractor because it only accepts String value.

[ISchwarz23]

Hi you can use SimpleDateFormat to turn you Date into a String.

SimpleDateFormat dateFormatter = new SimpleDateFormat("yyyy-MM-dd"); // TODO: adapt pattern

SimpleTableDataColumnAdapter c7 = new SimpleTableDataColumnAdapter<>(
    (SimpleTableDataColumnAdapter.StringValueExtractor) data -> dateFormatter.format(data.getCreatedOn()));

[sanakalam]

@ISchwarz23 Thanks For your Support.
I use below code it works:
SimpleDateFormat format = new SimpleDateFormat("dd-MM-yyyy");
tableView.setColumnComparator(6, new Comparator() {
@OverRide
public int compare(RequestInquiryModel o1, RequestInquiryModel o2) {
Date d1=null;
Date d2=null;
try {
d1=format.parse(o1.getCreatedOn());
d2=format.parse(o2.getCreatedOn());
} catch (ParseException e) {
e.printStackTrace();
}
return d1.compareTo(d2);
}