Hello everyone, I have a query - how do we get the last three months invoice from 1st date to 20th using saved search?
n
Netsuite Tragic
04/09/2024, 10:36 PM
So you want Dates 1-20 Jan, 1-20 Feb, 1-20 Mar? I would start with a criteria like CASE WHEN TO_CHAR({translate},āDā)<21 THEN 1 ELSE O END. Add another criteria to included your three (rolling) months.