Grid Configurator

I'm using a grid configurator in easy function mode.
I'm getting this error in the coresuitedebug log:

General error;266 inconsistent datatype: $[$Date01] is not a TIMESTAMP type const: line 7 col 26 (at pos 220)

My parameters:
$[$CardCode]
$[$Date1]
$[$Date2]

MY Query: (HANA)
SELECT T0."CardCode",T0."CardName",
T0."DocNum",T0."DocDate",T0."CANCELED",
T0."NumAtCard",T0."VatSum",T0."DocTotal"
FROM OINV T0
WHERE T0."CardCode" = '$[$CardCode]'
and T0."CANCELED" = 'N'
and T0."DocDate" BETWEEN '$[$Date01]' AND '$[$Date02]'

 

and my second question is there a posibility to have a TOTAL of a column or a rolling Total?

 

0

Comments

0 comments

Please sign in to leave a comment.

Didn't find what you were looking for?

New post