Exclude Time Data

[#1]

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.

texas_stats_1-1717433396828.png

Script in the Exclude column:

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

[#2 · Accepted solution]

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
);

[#3]

Awesome!  Thanks for the quick response.

[#4]

Thanks for answering, you made my day.