How can I add date-range search and pagination to a JSON-based table in LabVIEW?

[hwkim0418]

I have a JSON dataset that I parse into clusters and display in a table. I am using LabVIEW 2023 Q3.
Now I want to add:

1. Date-range filtering (example: show only data from 11/12/2025 to 11/13/2025)

2. Pagination (e.g., 20 rows per page)

My DATE field in JSON is a string like "20251112".
What is the recommended way to convert this into a timestamp, filter rows by date, and then display only the selected page using Array Subset or another method?

VI attached.

Thanks!

[GerdW]

Hi hwkim,

---

@hwkim0418 wrote:

My DATE field in JSON is a string like "20251112".
What is the recommended way to convert this into a timestamp, filter rows by date, and then display only the selected page using Array Subset or another method?

---

• Use ScanFromString to convert the string into a timestamp. See the explanations for the %<>T format code in the LabVIEW help!
• Use InRangeAndCoerce (in an autoindexing FOR loop with a conditional output tunnel) to filter by timestamps…
• ArraySubset is just fine to get a subset from an array…