Makedate in where

[#1]

Hello,

I´ve a column with time value and i need load whole records that are before 14:00 pm.

I´m using it 

   but isn´t work.

Thank you

time( DT_EVENTO)  <= maketime(14,10,0)

[SunilChauhan]

let vTime=MakeTime(10,20,30);

time( DT_EVENTO)  <=$( vTime) or '$( vTime)'

hope this helps

[MayilVahanan]

Hi

If u want the less than 14 hour means..simply u can hard code like it

Where

Hour(DI_Evento)   <= 14;

Hope it helps

[#4 · Accepted solution]

time( DT_OCORRENCIA ) <=  '$(vTime)PM'