Hi Sue

Sorry my error, I should have proof read it before posting it. It made sense in my head before i typed it

Maybe its better to put it like this

So today is the 4th sept 2017 our reporting dates for a year fall between the 1st april 2017 (for example) in this year to the 31st march 2018 in the following year. What I want to put as a start date is 1st april as a default and the year to stay the same between that period even though when we move to 2018 on the 1st Jan I want the date to remain 01/04/2017 until we reach the 1st of april 2018 when I want the reporting year to change to 2018 for the same 1st April date, This will be the same for the end/to date that it will default to 2018 until we go to the 1st April 2018 when the year will change to 2019. Im also guessing that the condition will have to so if greater than or equals to for the start date and if less than or equals to the end date so it shows the reporting data for the 1st april and the 31st March.

Hope this makes more sense than my original post 🙂

Thanks
Chris