Thank You for the reply.
The date variables are correct.
NAME: endDateTime
VALUE:17.10.2019 20:18:39
NAME: startDateTime
VALUE: 17.10.2018 20:18:39
I use them to fetch DocuRef records which are a year old from current day and have TypeId == URL.
The "or" statement is used without the date period.
The complete requirement for data selection is as follows:
Report should show all active BP (CustTable.Blocked=“no“ and VendTable. Blocked =“no“) related records in DocuRef table
where DocuRef.Type= “URL” if primary address (DirPartyPostalAddressView IsPrimary=”YES”)
country has mark “YES” “Sanctioned country” and last screening date is older than one year from today
and all active debtors and vendors (CustTable.Blocked=“no“ and VendTable. Blocked =“no“) records
with primary address (DirPartyPostalAddressView IsPrimary=”YES”)
country has mark “YES” “Sanctioned country” and without related records in DocuRef table where DocuRef.Type= “URL”.
I think the while select statement looks correct.
I am just testing on CustTable.
|