Hi I have to pull data for a report from 11/1/2013 to date. But once we get to 11/1/2014 then the report should pull data from 11/1/2014 to date and so on. Is there a way to do this? I guess I could go in and change the year manually but was hoping that there was a way to do this autmoatically.
so today would be tadate >= '11/1/2013'
but at any point between 11/1/2014 to 10/31/2015 it should be tadate >= '11/1/2014'