Expression pointage

[#1]

Comment corriger cette expression ci dessous pour quel me retourne dEvent_Date = '1' si le pointage avant 08:30 si non elle me retourne '0'

if(num(Hour(dEvent_Date))<='08' and num(Minute(dEvent_Date))<='30','1','0') as T830,

[antoniotiman]

Quel est le format de dEvent_Date ?

[#3]

11/06/2014 09:03

[#4 · Accepted solution]

if(num(Hour(dEvent_Date))<='08' and num(Minute(dEvent_Date))<='30' or ((num(Hour(dEvent_Date))<'08' and num(Minute(dEvent_Date))>'30')) ,'1','0') as T830,