Problem with if statement and time comparison

[#1]

Hello Everyone,

as usually i need your help

I've this if statement and i need it to create this dimension in a pivot or a listbox:

if(date(ACTION.TIME, 'hh:mm')<=date('14:30','hh:mm'),'Current Day','Following Days')

the date function recognize the hour and minutes and also the 14:30 for the right part but seems that qlik is not able to confront that.

Any suggestions?

Kind Regards,

Alfonso

[#2]

unfortunately not, but i can say that the problem is with right part... qlik is not able to recognize time#('14:30', 'hh:mm') like a time format

[PrashantSangle]

Hi,

Without sample apps it is difficult to provide solution.

but you can debug your own code, by taking each expression in  text object

check below in text object

1)

=time(ACTION.TIME, 'hh:mm')

2)

time(time#('14:30','hh:mm'),'hh:mm')

if it wont work

try with NUM() and frac()

like

num(time(ACTION.TIME, 'hh:mm'))<= num(time(time#('14:30','hh:mm'),'hh:mm'))

or

do same with frac()

Regards