https://netsuiteprofessionals.com logo
Title
d

DX

08/06/2019, 7:58 AM
can someone guide me on how to construct a search to display vendors whereby the last transaction date is say, a year ago? I have no clue on how to filter by last transaction date. Do I filter using "date last modified"? "date line last modified"? Or do I need to use a CASE formula which I don't know how to either 🤔
k

karlenigma

08/06/2019, 8:07 AM
In the summary fields you can do date and summary maximum and specify before 1 year ago
d

DX

08/06/2019, 10:03 AM
thx man. got it