This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Is there a way to make one column pull in a selected date and have another column pull is last years numbers to match in a report without having to hard code (select) the data range in the edit columns section?

Do you mean in Saved Search or Analytics?

Once approach
Col 1 This months amounts
Col 2 12 months Earlier

Your respective columns could be something like
COL 1 Formula DECODE(TO_CHAR({trandate},'Mon-YYYY'),TO_CHAR({today},'Mon-YYYY'),{amount},0)
COL 2 Formula DECODE(TO_CHAR({trandate},'Mon-YYYY'),TO_CHAR(ADD_MONTHS({today},-12),'Mon-YYYY'),{amount},0)

This would work for a selected date range,. For a specific date you could tighten the Criteria of the search with a expression like..
( Date = On [date] OR
date = same day last financial year {date] )

Then the original Col1 &amp; Col2 will only be getting the specific days.

There are limitations.