Within 24 Hours Flag

[prees959]

HI,

Im trying to set a flag to filter the document to Within 24 hours.

My expression is : if(hours_lead_time>=0 and  hours_lead_time<=24,1,0)

However when I filter on this flag within the document it shows hours above 24 hours.

The expression to create hours_lead_time is  interval(start_datetime-requested_on,'h')

Can anyone advise on this please?

Thanks,

Phil

[tresesco · Accepted solution]

If you see hour is 1, it is actually 1/24 at the back end. Hence try like:

if(hours_lead_time>=0 and  hours_lead_time<=1,1,0)

[prees959]

HI This has worked - but I cant understand why... Can you explain ?

Many thanks,

Phil