topic Re: Day - 1 not working in App Development

Day - 1 not working

Yedikapi — Tue, 26 Apr 2022 12:40:27 GMT

Hi,

I'm trying to add -1 day to my string variable varBeginDatum.

But it result 0 .

SnapshotDate_Stock_In_Use is date type.

varBeginDatum is string.

sum({< SnapshotDate_Stock_In_Use = {"$(=date(varBeginDatum-1))"}>} Qty_Stock_In_Use)

Where do I wrong ?

marcus_sommer — Tue, 26 Apr 2022 12:47:07 GMT

Only numeric value could be calculated against each other, means you need to convert the string to a number, maybe with something like:

$(=date(date#(varBeginDatum, 'FormatPattern')-1))

- Marcus

Yedikapi — Tue, 26 Apr 2022 12:52:07 GMT

It doesn't work for me .

I still get 0 as result.

Yedikapi — Tue, 26 Apr 2022 13:06:19 GMT

I've done following which has worked !

sum({< SnapshotDate_Stock_In_Use = {"$(=date(varBeginDatum-1,'YYYY-MM-DD'))"}>} Qty_Stock_In_Use)