Which SAP connector are you using? Is it possible to see your where clause?
Is this helpdful?
SQL SELECT PKey, Details
ModificationTime >= #$(LastExecTime)#
ModificationTime < #$(ThisExecTime)#;
LOAD PrimaryKey, Details
Inner Join SQL
IF ScriptErrorCount = 0 THEN
STORE T1 INTO T1.QVD (qvd);
LET LastExecTime = ThisExecTime;
Please check the script which i have defined in QLIK SENSE script editor when i extracted the data from SAP Source.
where Modified_Date>= '$(vLast_Date)';
when i do filer on Customer ID basis then where clause is working fine and gives me perfect result.
But when i do filter on Modified_Date then this where clause is not working , it is not filtering out the data.
i don't know may be the syntax of comparing with Date field is different in Qlik Sense.
Please help/Guide me on this.