calculating if a date is within a range

[Myke]

We have customers that are seasonal, and request their billing address is changed for certain periods of time... the problem I am having is getting a script or calcuation to recognize the range.

"LeaveDate > Get(CurrentDate)"

returns fine, but if I try

"LeaveDate > Get(CurrentDate) < ReturnDate"

or

"(LeaveDate > Get(CurrentDate)) and (Get(CurrentDate) < ReturnDate)

it fails the moment I ask it to compare that second date.

It seems like this should be a simple process, but everytime I try to have it fit into an actual range, it fails. Any ideas? Thanks

[aaa]

What date is start:

if LeaveDate is start of range and ReturnDate is EndDate then you must put

(LeaveDate < Get(CurrentDate)) and (Get(CurrentDate) < ReturnDate) else you must put "(LeaveDate < Get(CurrentDate)) and (Get(CurrentDate) > ReturnDate)