Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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)
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)