KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I'm trying to query through historical data and I need to return data just from a 1 month period: 2 weeks back and 2 weeks forward,but I need the year to not matter. So, if I was to make the query today I would want all rows with date between xxxx-06-31 and xxxx-07-27 Thanks in advance for the help! EDIT: I've tried two ways. both of which I believe will not work around the new year. One is to use datepart(day) and the other would be to simply take the year off of date and compare.
Tags (comma-separated)
Save Edits
Cancel