Skip to main content
pshashipreetham
pshashipreetham19-Tanzanite
19-Tanzanite
Apr 21, 2023 2:02 PM UTC
Solved

Get the latest Timestamp from Infotable

Hi,

 is there a way to get the latest timestamp entry from an InfoTable which has around 20 timestamps rows?

 

Thanks, 

pshashipreetham
pshashipreethamAnswer
19-Tanzanite
May 9, 2023 7:45 AM UTC

hi @Velkumar ,

 

Thanks for it; I am not sure how I missed it.

let sort = {
 name: "timestamp",
 ascending: false
};
result.Sort(sort);

 Thanks,

Shashi Preetham || +91 8099838801 || shashi@psptechhub.com
View in thread

3 replies

jensc17-Peridot
17-Peridot
Apr 21, 2023 3:09 PM UTC

Hello @pshashipreetham,

 

Here is some code that should do what you want:

 

// if your dates are strings
let objects = [
 { date: "2023-04-19" },
 { date: "2023-04-20" },
 { date: "2023-04-21" },
];

let newestDate = new Date(
 Math.max.apply(
 null,
 objects.map(function (obj) {
 return Date.parse(obj.date);
 })
 )
);

result = newestDate.toDateString(); // Output: Fri Apr 21 2023

// if your dates are dates
let objects = [
 { date: new Date("2023-04-19T12:00:00Z") },
 { date: new Date("2023-04-20T12:00:00Z") },
 { date: new Date("2023-04-21T12:00:00Z") },
];

let newestDate = new Date(Math.max.apply(null, objects.map(function(obj) {
 return obj.date.getTime();
})));

result = newestDate.toDateString(); // Output: Fri Apr 21 2023

 

Hope this helps.

 

Regards,

Jens

Translate
Velkumar19-Tanzanite
19-Tanzanite
Apr 22, 2023 2:25 PM UTC

Hi @pshashipreetham 

 

You can use the 'Sort' snippet to sort rows in InfoTable 

 

Velkumar_0-1682173483368.png

 

/VR

 

Translate
    pshashipreetham
    pshashipreetham19-TanzaniteAuthorAnswer
    19-Tanzanite
    May 9, 2023 7:45 AM UTC

    hi @Velkumar ,

     

    Thanks for it; I am not sure how I missed it.

    let sort = {
 name: "timestamp",
 ascending: false
};
result.Sort(sort);

     Thanks,

    Translate
    Shashi Preetham || +91 8099838801 || shashi@psptechhub.com
    Terms & ConditionsAccessibility statement