Date time sorting in react table on particular column (column name transaction date)

Question

I am using react table and wanted to sort date time but its not sorting properly either ascending order or descending order.

column defined code: Using below code to sort the date time.

{Header: 'Transaction Date',accessor: 'transationDate', style: {textAlign: "center"},
                          sortMethod: (a, b) => {
                            var a1 = new Date(a).getTime();
                            var b1 = new Date(b).getTime();
                          if(a1<b1)
                          return 1;
                          else if(a1<b1)
                          return -1;
                          else
                          return 0;
                          }
                        },

descending order Sorted Result:

Your if and else conditions are the same.

Anurag Srivastava
– Anurag Srivastava

2019-03-10 07:24:36 +00:00
Commented Mar 10, 2019 at 7:24 — Anurag Srivastava
– Anurag Srivastava, Commented Mar 10, 2019 at 7:24

Peer · Accepted Answer · 2020-11-26 11:22:45Z

5

I don´t know if anyone still struggles with that but for me 'sortType' did the magic instead of 'sortMethod'.

{Header: 'Transaction Date',accessor: 'transationDate', style: {textAlign: "center"},
                      sortType: (a, b) => {
                        var a1 = new Date(a).getTime();
                        var b1 = new Date(b).getTime();
                      if(a1<b1)
                      return 1;
                      else if(a1>b1)
                      return -1;
                      else
                      return 0;
                      }
                    },

answered Nov 26, 2020 at 11:22

Peer

2414 silver badges10 bronze badges

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

Comments

Tetsuya3850 · Accepted Answer · 2019-03-10 07:31:44Z

3

This should work! Just flip the < with >.

{Header: 'Transaction Date',accessor: 'transationDate', style: {textAlign: "center"},
                          sortMethod: (a, b) => {
                            var a1 = new Date(a).getTime();
                            var b1 = new Date(b).getTime();
                          if(a1<b1)
                          return 1;
                          else if(a1>b1)
                          return -1;
                          else
                          return 0;
                          }
                        },

answered Mar 10, 2019 at 7:31

Tetsuya3850

1,0391 gold badge8 silver badges16 bronze badges

1 Comment

Riya Kumari Over a year ago

I tried but still its not sorting. Could you please suggest any thing else?

Collectives™ on Stack Overflow

Date time sorting in react table on particular column (column name transaction date)

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related