Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
I've done following which has worked !
sum({< SnapshotDate_Stock_In_Use = {"$(=date(varBeginDatum-1,'YYYY-MM-DD'))"}>} Qty_Stock_In_Use)
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
It doesn't work for me .
I still get 0 as result.
I've done following which has worked !
sum({< SnapshotDate_Stock_In_Use = {"$(=date(varBeginDatum-1,'YYYY-MM-DD'))"}>} Qty_Stock_In_Use)