Anyway you could add a "date" field to column types to sort on?

[bbennett36]

I could probably hack something together or edit the current component but I'm sure you could do this more efficiently than me. Just let me know, thanks!

[xaksis]

Don't sell yourself short friend! You would have done a fine job i'm sure. I used moment to parse/format dates. you can find the changes in version 1.4.0.

[xaksis]

Example usage:
you can add a column like so:

{
          label: 'Created On',
          field: 'createdAt',
          type: 'date',
          inputFormat: 'YYYYMMDD',
          outputFormat: 'MMM Do YY',
          filterable: false,
        },

and your date should look like '20160423' //depending on the format you specify in inputFormat.

[bbennett36]

Awesome! Thanks, I appreciate it!

[xaksis]

No problem! let me know if you have a problem using it.

[bbennett36]

Sounds good, ill do some testing tomorrow and report back with the results.

…

On Jun 1, 2017 7:14 PM, "xaksis" ***@***.***> wrote: No problem! let me know if you have a problem using it. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#4 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AG9Inz3n2TM3JDi0DqCVY-340DtxGWzgks5r_0XFgaJpZM4NtdFg> .

[bbennett36]

I got that working but it looked like there was an error in your sort method.

I had to change

  if (this.columns[this.sortColumn].field === 'date') {
                x = moment(x + '', this.columns[this.sortColumn].inputFormat);
              }

to

  if (this.columns[this.sortColumn].type === 'date') {
                x = moment(x + '', this.columns[this.sortColumn].inputFormat);
              }

Looks like you have it looking at the field name instead of the field type. My field name was "due_date" so it wasn't working at first and I had to go through and change that.

Other than that, it works great. Thanks again!

[xaksis]

whoops! good catch... 1 fix coming right up.

[xaksis]

v1.4.1

[xaksis]

@bbennett36 I just switched out the date parsing/formatting library. Please let me know if all your use cases still work fine? Thank you!

[bbennett36]

Are you able to use the 'defaultsortby' setting on a date field? Mine doesn''t seem to be working. The regular date sorting is still working perfect though.