I'm surprised this calculated field didn't throw an error (let alone just one of the < not working as expected)...
So you need to have the [Transactiondate] for both sides of the AND, so would be
[Transactiondate] > #31/08/2014# AND [Transactiondate]< #21/03/2015# THEN "1"
[Transactiondate] > #31/08/2015# AND [Transactiondate]< #21/03/2016# THEN "2"
I've altered the date range, as superstore only goes up to 2014, but the attached (in 9.3) is doing what you need...let me know if not.
Date Between - SR.twbx 465.7 KB
Thanks you very much. Now it works.