Two Columns This Year `decode to char suitable date field YY NetSuite Professionals #general

Two Columns: This Year: `decode((to_char({suitable...

KevinJ of Kansas

10/08/2019, 3:12 PM

Two Columns: This Year:

decode((to_char({suitable date field}, 'YYYY'),to_char({today},'yyyy'),{quantity},0)

Last Year:

decode((to_char({suitable date field}, 'YYYY'),to_char(add_months({today},-12),'yyyy'),{quantity},0)