Recursive timer between hours

Did you test this? hour() returns 0-23. Should be OK.

Right, excuse me and a question I am putting the condition in a rule because the values ​​of StartDate, EndDate, I must frequently collect them from the database, the rule is this:

load(

local!horaIni: split(
local!fechaIni,
":"
)[1],
local!minutoIni: split(
local!fechaIni,
":"
)[2],
local!horaFin: split(
local!fechaFin,
":"
)[1],
local!minutoFin: split(
local!fechaFin,
":"
)[2],
/*Se comprueban las condiciones para ver si el proceso debe ejecutarse o no*/
if(
and(
time(
hour(
local(
now()
)
),
minute(
local(
now()
)
)
) >= time(
local!horaIni,
local!minutoIni
),
time(
hour(
local(
now()
)
),
minute(
local(
now()
)
)
) <= time(
local!horaFin,
local!minutoFin
),
local!activo = "S"
),
true(),
false()
)
)

Where the values ​​of startDate, EndDate and asset are values ​​retrieved from bbdd(values ​​are string)

and the frequency would be a query to bbdd that retrieves this value

This is the timer setting

Executing the rule separately returns true

Do you know why the process does not start?

Greetings and thank you

Right, excuse me and a question I am putting the condition in a rule because the values ​​of StartDate, EndDate, I must frequently collect them from the database, the rule is this:

load(

local!horaIni: split(
local!fechaIni,
":"
)[1],
local!minutoIni: split(
local!fechaIni,
":"
)[2],
local!horaFin: split(
local!fechaFin,
":"
)[1],
local!minutoFin: split(
local!fechaFin,
":"
)[2],
/*Se comprueban las condiciones para ver si el proceso debe ejecutarse o no*/
if(
and(
time(
hour(
local(
now()
)
),
minute(
local(
now()
)
)
) >= time(
local!horaIni,
local!minutoIni
),
time(
hour(
local(
now()
)
),
minute(
local(
now()
)
)
) <= time(
local!horaFin,
local!minutoFin
),
local!activo = "S"
),
true(),
false()
)
)

Where the values ​​of startDate, EndDate and asset are values ​​retrieved from bbdd(values ​​are string)

and the frequency would be a query to bbdd that retrieves this value

This is the timer setting

Executing the rule separately returns true

Do you know why the process does not start?

Greetings and thank you

We have continued doing tests and we have seen that the condition in the node does not do well, if it has a load or with the queries to bbdd, it only works well if we put the values ​​in constants but what they ask us is that those values ​​are in bbdd, any ideas?

Greetings and thank you