Time Between & Date Between

[selbjx]

Do any such functions exist which cover the above operations?

I need to find times between certain time ranges and can see no simple way of doing this.

[Hovik]

You can do arithmetic with date and time fields. e.g.

Code: Select all

set TDIFF = END_TIME - START_TIME;

where START_TIME and END_TIME are both TIME fields.

If TDIFF is an integer field, the result will be number of seconds. if TDIFF is a time field, the result will be a time in format HH:MM:SS

You can use the same approach with dates, except subtracting 2 dates will give you number of days (you can not put the result in another date field).

[selbjx]

Thanks for the response Hovik.

I've been a bit slack in my detail and I've now worked through the issue.

What I actually wanted was a function to do the following:

I have a time range, say 07:00- 16:59 and needed to know whether 12:00 is in this range. I quickly put together a little function which does what I needed.

Many thanks

Jon

[Hovik]

Hi Jon,

You can also compare date and time fields. e.g.

Code: Select all

if &#91;MID_TIME >= START_TIME and MID_TIME <= END_TIME&#93;

[selbjx]

Hi Jon,

You can also compare date and time fields. e.g.

Code: Select all

if &#91;MID_TIME >= START_TIME and MID_TIME <= END_TIME&#93;

Odd, i'll give that another try tomorrow - it didn't work for me first time round, hence why I opted to build a java function.

Cheers

[selbjx]

Hi hovik,

Now resolved, thanks for your help, much appreciated

Jon