Highlight row if more than 1 day old

[patsd]

Hi all.

I am trying to highlight a row in a database if it's more than 1 day old,

I'm trying this, but it's making all the dates highlighted.

TIA
Pat

$j(function(){
            
      $j('.louth-entereddate').each(function(){
        var today = new Date();
                if(d.setDate(d.getDate() - 1){
            $j(this).parents('tr').addClass('warning');
        }


      })
    })

 

[Padonak]

What d stands for in your code?

 

[patsd]

I removed the D's
Not working,

 

[Drogby]

Hi Pat,

The issue with your code is that you're not fetching the date value for each row and comparing it with today's date. Instead, you're just creating a new date object and comparing it with yesterday's date which is causing all dates to be highlighted.

You need to fetch the date value from the row and compare it with today's date after subtracting one day from it. Here's an updated code snippet for you:

$j(function(){
    $j('.louth-entereddate').each(function(){
        var enteredDate = new Date($j(this).text()); //fetch date value from row
        var yesterday = new Date(today.getTime() - (24 * 60 * 60 * 1000)); //subtract one day from today's date
        if (enteredDate < yesterday) { //compare date values
            $j(this).parents('tr').addClass('warning');
        }
    });
});

This code will fetch the date value from each row and compare it with today's date after subtracting one day. If the entered date is more than one day old, it will add the `warning` class to the parent row and highlight it.

Let me know if you have any questions!

 

[patsd]

Hi Drogdy,
Thanks for the code,
unfortunately it's not working,

 

[patsd]

Still not working,
I'm trying this

    $j(function() {
        $j('.louth-entereddate').each(function() {
            var d = $j(this).text().split("/");
            entereddate = new Date(d[2] + '/' + d[1] + '/' + d[0]);
            var yesterday = new Date(new Date().getTime() - (24 * 60 * 60 * 1000));
            if (entereddate < yesterday) {
                $j(this).parents('tr').addClass('warning');
            }
        });
    });

 

[FResher]

hello ! I have a question ( 3 by the way )

"if it's more than 1 day old" means 'not today' ?

'today' display is different ?
or your requirement is "today and yesterday" have a different display ?

 

[patsd]

To close this post, I used https://momentjs.com/docs/#/manipulating/subtract/
Thanks for all your help here,

Pat