Previous financial year - dates in a parameter in SSRS

Question

Hello

I currently use:

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

and

=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

Answer 1

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】

Regards,

Zoe

---

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.