Calculation based to time

[Devin]

I thought this issues was going to be simple, but it turns out woking with time is something I've not been able to wrap my head around.

Can someone please tell me what is wrong with doing this.

If ( Get ( CurrentTime ) > "12:00:00 AM"; If ( Get ( CurrentTime ) < "03:00:00 AM" ; "TRUE" ; "FALSE" ) ; "FALSE" )

 

What I'm trying to do is find out if the the current time falls between two different times in the day.

I want to know if the current time is between 12am and 2:59 AM and return a True or False statement..

[eos]

want to know if the current time is between 12am and 2:59 AM and return a True or False statement..

Use Time() to construct a value that you can safely compare to Get ( CurrentTime ):

Get ( CurrentTime ) > Time ( 0 ; 0 ; 0 ) and Get ( CurrentTime ) < Time ( 3 ; 0 ; 0 )

is True or False; no need to use If().

Note also that "True" and False" is merely text; the keywords True and False are written without quotes.

[Raybaudi]

"12:00:00 AM" and "03:00:00 AM" aren't times, but strings.
Use Time ( 12 ; 0 ; 0 ) and Time ( 3 ; 0 ; 0 ) instead.

[Devin]

Use Time() to construct a value that you can safely compare to Get ( CurrentTime ):

Get ( CurrentTime ) > Time ( 0 ; 0 ; 0 ) and Get ( CurrentTime ) < Time ( 3 ; 0 ; 0 )

is True or False; no need to use If().

How does it know the difference between AM an PM? Are we to use the 24 hour clock if needed.

Thanks for the help..

[eos]

Are we to use the 24 hour clock if needed.

Yes.

[Devin]

Perfect.. Looks like this is working.

Thanks four you help.

[comment]

I want to know if the current time is between 12am and 2:59 AM and return a True or False statement..

Well, if the exact midnight can be included in the range, then you could simplify your test to:

Get ( CurrentTime ) < Time ( 3 ; 0 ; 0 )

or, if you prefer:

Get ( CurrentTime ) < 10800

as the current time will never be negative.

Edited July 2, 2015 by comment