Experts,
I have a customer who wants a query to show only Invoices that after 30 days of posting do not have a UDF filled in. This is on SAP HANA could and I started this query with the generator, which added the ".
The red part is which gives me errors, without that the query is correct.
SELECT T0."DocNum", T0."DocDate", T0."CardName", T0."U_L", T0."U_ACC_02", T0."U_ACC", T0."U_ACC_01", T0."PaidToDate", T0."DocTotal" FROM OINV T0
WHERE T0."DocDate" >= dateadd(day,datediff(day,30,GETDATE()),0)
AND T0."DocDate" < dateadd(day,datediff(day,0,GETDATE()),0)
AND T0."U_ACC_01" IS NULL
Your help would be appreciated,
Marli