PrimeNG data table: Issue while sorting a date column

Question

I am using PrimeNG Data table, table has multiple columns, one of them is date column with date format like 'DD MMM YYYY, hh:mm' How can I sort by date a column without changing date format? I assume it sorts by its string value because it doesn't sort correctly,

Is there any workaround or fix for this issue?

Thanks

Alex Choroshin · Accepted Answer · 2023-02-15 08:52:48Z

1

I'm not sure about PrimeNG but I think that you can have two properties date and dateToSort (dateToSort is the date in format YYYYMMDD and indicate that the column to order is dateToSort

<ng-template pTemplate="header" let-columns>
  <tr>
    <th *ngFor="let col of columns" 
        [pSortableColumn]="col.field=="date"?"datesort":col.field">
                {{col.header}}
        <p-sortIcon [field]="col.field"></p-sortIcon>
    </th>
  </tr>
</ng-template>

Some looks like in this SO about material table

edited Feb 15, 2023 at 8:52

Alex Choroshin

6,1872 gold badges31 silver badges36 bronze badges

answered May 24, 2021 at 16:41

Eliseo

58.9k4 gold badges39 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PrimeNG data table: Issue while sorting a date column

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related