We use Microsoft Sql Reporting Serives 2005. Some of our reports require a calculation to be made that works out the difference in days between the start of the financial year (i.e. 1st of July) to a date stored in in each record. Can anyone think of an expression that calculates the date of the start of the current financial year. ie. this year the date would be 1/7/2009 and next year it would be 1/7/2010 etc
I don't want to have to manually change the date everytime the year changes.