where clause need to be replaced in qlik

[aniruddhyadutta]

Hi All,

I hdo have an oracle sql where its using a  particular condition in where clause  which I need to do in qlik

which is something like this below

2359 - (30 - to_number(to_char(SYSDATE, 'HH24MI'))) < to_number(schedule_time)

can anyone help me to understand this and convert it to qlik equivalent.

cheers!

AD

[girirajsinh]

Hi Aniruddhya

You may try something like below in where clause of load

2359-(30-num#(hour(now()))<num#(field)

check our more date time related functions and formats here

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/d...

Let me know how it goes.