AND operator in calculated field

[yuvi]

I'm trying to write a conditional using AND to create a calculated field in my table but getting a syntax error saying missing right parenthesis.  

This is what I have:

If(floor(EndDate)-floor(OrderDate)>30 and floor(endDate)-floor(OrderDate)<=60, floor(EndDate)-floor(OrderDate),0)

For context: the calculated field will output aging analysis for orders with 30-60 days from the cutoff date. So if the difference in endDate and orderDate is between 30-60, it will calculate the number of days it has from 30. So diff of 34 would be 4. 

[BrunPierre]

Hi, this is what I would do.

If(Interval(Floor(EndDate) - Floor(OrderDate), 'D') > 30 and Interval(Floor(EndDate) - Floor(OrderDate), 'D') <= 60, Interval(Floor(EndDate) - Floor(OrderDate), 'D'), 0)