Hello, Wondering if anyone would know how to do date search formula in the criteria, maybe a case when: the date criteria would be a rolling 180 days back from today?

CASE WHEN {trandate} BETWEEN (SYSDATE - 180) AND SYSDATE THEN 1 ELSE 0 END

You can also do this in the UI with relative dates instead of formula

@Gregory @Michael McNamara you guys rock. Thank you

Anytime! Spread the love and try and help a fellow NetSuite user out, so we can this group the best possible.