I want to be able to return all records that are greater than 4 weeks from the date received. I want to use the following query is this possible?
select ponum, count(itemnum) as itemnum, count(invoicenum) as invoicenum
from poreceiv
where ponum = '#get_po_item.ponum#'
and itemnum = '#get_po_item.item#'
and datereceived > #dateadd("ww", -4, datereceived)#
select ponum, count(itemnum) as itemnum, count(invoicenum) as invoicenum
from poreceiv
where ponum = '#get_po_item.ponum#'
and itemnum = '#get_po_item.item#'
and datereceived > #dateadd("ww", -4, datereceived)#