Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Makedate in where

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)

1 Solution

Accepted Solutions
Not applicable
Author

 

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

View solution in original post

3 Replies
SunilChauhan
Champion
Champion

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

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

hope this helps

Sunil Chauhan
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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

 

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