Hello, I have a data column named Date_In with format of 20-May-13. How can I filter the data to select based on year only. I used
Where Year(Date_in) = 2014
This code is not working.
I also need a way to automatically update to next week range. For example, last week I used where function like this
Where Date_in = to_date('01/12/2014','MM/DD/YYYY')
Is there a way it will automatically at the next 7 days to the code above when the date is available. This week I have to go back and changed the code in to this:
Where Date_in = to_date('01/19/2014','MM/DD/YYYY')