Loading

Retrieve Previous Years Data From SQL Server

Jes Sie

I need an assistance again. Below is a snippet where I get a record from year to date:

What I need now is to get the record from previous year of the same date.

Thank you in advance.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jes Sie6y ago
Just found a soloution to my question
where DateIssued BETWEEN dateadd(YEAR, datediff(YEAR, 0, getutcdate())-1,0) and dateadd(year, -1, getutcdate()) AND Remarks<> 'Cancel'