add string to variable

Yedikapi — Tue, 26 Apr 2022 11:36:56 GMT

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 ?

Re: add string to variable

hic — Tue, 26 Apr 2022 11:54:31 GMT

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)

topic Re: add string to variable in App Development

add string to variable

Re: add string to variable