How do I select rows within a specific time range and create a new column using the selected rows?

Question

For example, I only wanted to select rows when the time is between 7pm-10pm. How do I create a column with the selected rows within the specified time range?

Example.jmp

ian_jmp · Accepted Answer

Using the 'Hour()' function (see 'Help > Scripting Index'), you could add a new column with a formula such as:

Hour( :test_start_date ) >= 19 & Hour( :test_start_date ) <= 22