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 Select *From apps.xdmc_852@erpprodWhere 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 thisWhere 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')TDN
Filter Query By Year & change dated automatically
Posted - 2014-01-21 : 12:34:24
