I need an assistance again. Below is a snippet where I get a record from year to date:
- WHERE (DateIssued between
- DATEADD(YEAR, DATEDIFF(YEAR, 0, GETDATE()), 0) and
- DATEADD(MILLISECOND, -3, DATEADD(YEAR, DATEDIFF(YEAR, 0, GETDATE()) + 1, 0)))
What I need now is to get the record from previous year of the same date.
Thank you in advance.