Date Range Syntax

[Marc]

I am trying to create a formula that indicates when the "Finish Date" falls
into certain ranges, but I am unsure of the syntax to use.

Here is the first portion that DOES work:
IIf((ProjDateDiff(datevalue([Finish]),Datevalue([Current Date]),[Project
Calendar])/480)<30,"Finish Less Than 1 Month"

Here is what I CAN'T get to work:
I want to identify those that are scheduled to finish greater than 30 days
but less than 60 days. I would THINK it would be something like this:
IIf((ProjDateDiff(datevalue([Finish]),Datevalue([Current Date]),[Project
Calendar])/480)>30<59 --- BUT, it doesn like the "<59" piece. What am I
doing wrong?

Any help will be GREATLY appreciated!

 

[JackD]

Use an "AND" like this:

iif((myterm>30) AND (myterm<59),"finish between one and two
months","whatever")