How to get value between 2 dates

[johnob]

Hi all

Im trying to get the value of the following code ..

The result of the below fourmula is 54 (that is as long as the program has been running), but I need the answer to be 7 (that is the value from today and the last 14 days)

 =[Reports]![Results <4 and >14]![Result<4Total]

I have used

 =[Reports]![Results <4 and >14]![Result<4Total] Between Date()-14 and Date()

But that gives the result of 0

Any comments welcome

Thank you