topic Re: Exclude Time Data in Discussions

Exclude Time Data

texas_stats — Mon, 03 Jun 2024 16:50:59 GMT

Hello,

I have a column that is in Date-Time format. I would like to exclude rows where the time includes 04:00:00, but my script isn't working. Any help is appreciated.

Script in the Exclude column:

If( Contains( Format(:DT, "hh:mm:ss"), "04:00:00"),
	1,
	0
)

Re: Exclude Time Data

jthi — Mon, 03 Jun 2024 16:54:51 GMT

You can check for the time of day

If(Time Of Day(:DT) == In Hours(4),
	1
,
	0
);

Few examples

Show(
	Time Of Day(03Jun2024:04:00:00) == In Hours(4), // 1
	Time Of Day(03Jun2024:04:10:00) == In Hours(4), // 0
	Time Of Day(03Jun2024:05:00:00) == In Hours(4) // 0
);

Re: Exclude Time Data

texas_stats — Mon, 03 Jun 2024 17:08:23 GMT

Awesome! Thanks for the quick response.

Re: Exclude Time Data

CalebRogers — Mon, 10 Jun 2024 10:23:20 GMT

Thanks for answering, you made my day.