Determine if time is between certain hours

Elby — Wed, 29 Aug 2018 19:02:15 GMT

Casual jmp 12 user

How do I have jmp determine if a time is between certain hours on any day?

I want to create a column to show (Y/N) if the time when data was taken is between 12:00 AM and 7:00 AM. So the below data points would be Yes then No.

Data taken at random times and transferred into jmp as shown in the examples below.

Data (Example) Between 12 and 7? (Desired result)

11/11/2017 6:44 AM Y
11/12/2017 5:28 PM N

Re: Determine if time is between certain hours

uday_guntupalli — Wed, 29 Aug 2018 19:11:28 GMT

@Elby:

dt = Current Data Table(); 

dt << New Column("Check",Character,Nominal,Formula(If(Hour(:Data) >= 7 & Hour(:Data) <= 12,"Y","N")));

topic Re: Determine if time is between certain hours in Discussions

Determine if time is between certain hours

Re: Determine if time is between certain hours