Getting time range in the load scripting

[#1]

Hi,

I would like to get something like

if(Interval(date1-date2,'hh:mm:ss') between '1:00:00' and '24:00:00", EmpID).

Please assist. I'm trying to show all values between a date range that is in is hh:mm:ss format in my load script, thanks.

Regards,

Mpho

[Siva_Sankar]

Use Interval#() instead, interval() function. Interval# interval#(expression [ , format-code ]) The interval# function evaluates the expression as a time interval according to the string given as a format-code. If the format code is omitted, the time format set in the operating system is used. The interval# function generally behaves just like the time# function but while times can never be greater than 23:59:59 (numeric value 0.99999) or smaller than 00:00:00 (numeric value 0.00000) an interval may have any value. Examples: The examples below assume the following operating system settings: Short date format: YY-MM-DD Time format: hh:mm:ss Number decimal separator: . interval#( A, 'D hh:mm' ) where A=1 09:00 returns:   String 1 09:00 Number 1.375 Regards. siva