topic Re: How do I select rows within a specific time range and create a new column using the selected rows? in Discussions

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

Danial1 — Sat, 10 Jun 2023 23:22:25 GMT

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?

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

ian_jmp — Wed, 18 Nov 2020 10:38:23 GMT

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

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

Danial1 — Wed, 18 Nov 2020 20:32:33 GMT

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