Link to home
Start Free TrialLog in
Avatar of protocol1
protocol1Flag for United States of America

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
Avatar of Bill Prew
Bill Prew

I haven't worked with Reporting Services, but would this need to be a SQL expression?

~bp
I think you want an SSRS Expression, don't you?  I am trying to work one out.
Avatar of protocol1

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
ASKER CERTIFIED SOLUTION
Avatar of Chris Luttrell
Chris Luttrell
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Excellent, that's exactly what I needed.

Thanks
Scott