Set start date to current Fiscal Year
Posted on 2013-09-16
I have a report where I am hardcoding the start date and I'd like to make it dynamically set the start date.
If today is equal to or greater than May 1 then set the start date to May 1st of this year.
If today is earlier than May 1 then set the start date to May 1st of last year.
I've already got a where clause of (Wdate > CONVERT(DATETIME, '2013-05-01 00:00:00', 102)) and I'm just having a brain-freeze on how to incorporate it in this where statement. I think I take the '2013-05-01 00:00:00' and replace it with an if statement but I'm coming up blank when I try to figure this out. I could also create a parameter but there isn't easier on the brain cells right now.
If anyone can help out I'd be eternally grateful!!