topic Re: Compare two variable of time... in QlikView

Compare two variable of time...

Mon, 03 Jun 2013 11:07:00 GMT

Hello!

I try to compare two variable in the loading script. Current time must fall within a specified time interval

My script:

let vTimeStart = '05:00am';

let vTimeEnd = '05:30am';

let curTime = time#(time((num#(Left(now(1),4))/2400),'hh:mmtt'),'HH:MMTT');

if time('$(curTime)','HH:MMTT') >= time('$(vTimeStart)', 'HH:MMTT') and (time('$(curTime)', 'HH:MMTT') <= time('$(vTimeStart)', 'HH:MMTT')) - error in this row

//some script

endif

Thanks!

Re: Compare two variable of time...

Gysbert_Wassenaar — Mon, 03 Jun 2013 11:16:52 GMT

let vTimeStart = time#('05:00am','hh:mmtt');

let vTimeEnd = time#('05:30am';'hh:mmtt');

let curTime = frac(now());

if $(curTime) >= $(vTimeStart) and $(curTime) <= $(vTimeEnd) then

// true

else

// false

end if;

Re: Compare two variable of time...

kumarnatarajan — Mon, 03 Jun 2013 11:29:59 GMT

hi,

try this.

Ex;

let vTimeStart = Timestamp(Timestamp#('05:00am','hh:mmtt'),'hh:mmTT');

let vTimeEnd = Timestamp(Timestamp#('05:30am','hh:mmtt'),'hh:mmTT');

let curTime = Timestamp(now(),'hh:mmTT');

if '$(curTime)' >= '$(vTimeStart)' and '$(curTime)' <= '$(vTimeStart)' then
set vCondition='True';
ELSE
set vCondition='False';
endif