protocol1
asked on
calulate start of financial year in Sql Reporting Services
Hi
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.
Many Thanks
Scott
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.
Many Thanks
Scott
I think you want an SSRS Expression, don't you? I am trying to work one out.
ASKER
Yes I'm after an SSRS Expression as the caculation is being done by a report filter rather than a SQL query
Thanks
Scott
Thanks
Scott
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent, that's exactly what I needed.
Thanks
Scott
Thanks
Scott
~bp