Previous financial year - dates in a parameter in SSRS

Will Faulkner 201 Reputation points


I currently use:

=IIF(Today() >= DateSerial(Year(Today()), 4, 1),DateSerial(Year(Today()), 4, 1), DateSerial(Year(Today()) - 1, 4, 1))


=DATESERIAL(Year(Now()) + (IIF(format(now(),"MMdd") > "0331",1,0)) ,3,31)

to get me the current financial year (UK) dates, eg 1/4/2020 - 31/3/2021

Please can you advise how I'd adapt these to bring through the previous financial year, e.g:

1/4/2019 - 31/3/2020 ?

Many thanks

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,735 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 30,881 Reputation points

    Hi @Will Faulkner ,

    You may try like this:

    =DATESERIAL(cstr(Year(today())-1) - (IIF(format(now(),"MMdd") > "0331",0,1)) ,4,1) 【1/4/2019】

    =DATESERIAL(cstr(Year(Now())-1) + (IIF(format(now(),"MMdd") > "0331",1,0)) ,3,31) 【31/3/2020】



    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    2 people found this answer helpful.

0 additional answers

Sort by: Most helpful