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…

[hwkim0418]

Hello, GerdW.

I really appreciate your feedback. I revised my code based on your comments, but it’s still not working as expected.

Could you please give me a bit more direction or some additional hints? I’ve attached my revised code for reference.

Best wishes, 

Hyunwook Kim

[GerdW]

Hi Kim,

---

@hwkim0418 wrote:

Could you please give me a bit more direction or some additional hints? I’ve attached my revised code for reference.

---

Did you notice the signature line in my message?

(I prefer LV2019. Please downconvert your VI and attach again: File menu -> Save for previous)