add string to variable

[Yedikapi]

Hi,

I'm trying to add Time into the variable and so to search my CorrectionTime

Sum({< CorrectionTime={">(=$(varBeginDatum)+ ' 00:00:00')<=(=$(varEindDatum) + ' 23:26:00')"}>} Qty_Recipe_Correction)

Result is always 0 .

I'm actually trying the sql statement

WHERE c.CorrectionTime >= @dateFrom
AND c.CorrectionTime <= DATEADD(MINUTE, 26, DATEADD(HOUR, 23, CAST(@dateTo as datetime)))

What is incorrect ? Can someone help me, please ?

[hic · Accepted solution]

It depends on the format of CorrectionTime and the format of your variables, but I would try something like

Sum({<CorrectionTime={">$(=TimeStamp(varBeginDatum))<=$(=TimeStamp(varEindDatum+'23:26:00'))"}>} Qty_Recipe_Correction)