Actually i am using this as a sub query inside my view, Declaring a date won't work because it should work for coming year records too..