Selecting data for last year using date column

penalah — Sat, 10 Jun 2023 23:52:32 GMT

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.

Re: Selecting data for last year using date column

txnelson — Thu, 04 Aug 2022 20:13:04 GMT

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