If else statement

[#1]

Hi ,

I am getting the error as error in expression when i tried to use the if else statement in the chart.

= if(((Time(Date,'hh:mm:ss')>='13:00:00PM') and (Time(Date,'hh:mm:ss')<='20:59:59PM')),'Shift 1',(((Time(Date,'hh:mm:ss')>='21:00:00PM')and(Time(Date,'hh:mm:ss')<='04:59:59PM')),'Shift 2','Shift 3'))

[#2]

Hi,

I have fixed the issue. It is the problem with the if statement.