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

[#1]

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?

Danial1_0-1605693947009.png

[#2 · Accepted solution]

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

[#3]

Thanks a lot for the prompt response. It helped a tonne!