find range with ...

[tbeidler]

Is this cdml correct?

FMPro?-DB=request.fp4&-Lay=duedate_schedule&-Format=cs_duedate.htm&due_date_calc=1...2&-Op=neq&sta (it continues).

I created a field called due_date_calc that returns a 1 if it's due in a week, 2 due in two weeks, etc. I then created a jump menu, with the cdml above, that finds requests due in one week, two weeks, one month.

It doesn't seem to be working correctly.

How can you search by range with a cdml link?

------------------

~~~~~~~~~~~~~~~~~~~~~~~~~

Tom Beidler

Orbit Tech Services

tbeidler@mindsprin

g.com

~~~~~~~~~~~~~~~~~~~~~~~~~

[Vaughan]

Why not make another calc field in the database that does the work for you.

For instance, the calc field could return intergers equal to and less than the weeks value: ie 2 weeks, the calc field produces "1 2" that way a search for items due two weeks and less will be found by searching on that field.

[tbeidler]

Sounds good, thanks.

I ended up using an operator. I changed the cdml to:

&-Op=lte&due_date_calc=2

The operator lte is for less than or equal to. That way it finds items with a due_date_calc of 2 or less.