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: 
anuradhaa
Partner - Creator II
Partner - Creator II

if statements with Hours and minutes

Hi ,

I have taken reload hour and minutes using below expression.

Time(Frac(ReloadTime()),'hh:mm')

Now i want to check that hour and minute with pre define minutes

If that Time(Frac(ReloadTime()),'hh:mm') value is grater than 06:30 i want to say 'Y' and else 'N'

Thanks

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

This will do it:

=If(Frac(ReloadTime()) *24 > 6.5, 'Y', 'N')

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

4 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

This will do it:

=If(Frac(ReloadTime()) *24 > 6.5, 'Y', 'N')

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Kushal_Chawda

=if(Time(ReloadTime(),'hh:mm') > time#('06:30','hh:mm'), 'Y','N') as TimeFlag

todtliat01
Partner - Contributor III
Partner - Contributor III

This way you can change the time limit as well

if(Num(Time(Frac(ReloadTime()),'hh:mm'))>Num(Time(Frac('06:30'),'hh:mm')), 'Y', 'N')

anuradhaa
Partner - Creator II
Partner - Creator II
Author

Thanks jonathan