Check if date older than 3 month

Check if date older than 3 month

TomasHelsenTomasHelsen Posts: 5Questions: 2Answers: 0

Hi,

Is there an easy way to check if the dates in a column is older than 3 months?
The date format is YYYY-MM-DD.
If the date is more than 3 month the text should be red.

Thanks
Tomas

Answers

  • colincolin Posts: 15,240Questions: 1Answers: 2,599
    edited March 18

    It's worth taking a look Moment.js, as it's excellent for all time/date based operations.

    Then you can use rowCallback to colour the cell, as demonstrated in this example,

    Colin

Sign In or Register to comment.