Selecting data for last year using date column

[#1]

Hello,

I'm in the process of getting only previous year data(i.e., from Jan 2021 till Dec 2021) and am having trouble selecting the data I need.

I would like the script to select all dates from January 2021 to December 2021 and nothing else.

Thanks in advance.

[#2]

dt << select where(:date >= date mdy(01,01,2021) & :date <= datemdy(12,31,2021 ));