Hi all,

I would like to show records in a portal that fall between a user definable date (month) range. The start date would always be the current date and end date would be a user definable month. The related file does have a date field called "end date". ie. Show me the records between now and 3 months.

Could this also work in reverse ie. Show me the records between now and the last 3 months.

Thanks in advance

Ian

You can either use a range plugin (Troi Ranges, Ranges tool box and the like) or take a look at Mikhail Edoshin's Smart ranges at

http://www.onegasoft.com

why not browse the forums here. there are a couple of excellent solutions buried in the forums, just search for "range".

I think you can find some very good examples on the thread that is at http://www.fmforums.com/threads/showflat.php?Cat=&Board=UBB6&Number=61669&page=0&view=&sb=5&o=&fpart=1&vc=1

I have downloaded one that we are now using for my work, and it is comparing two ranges with each other, but I think you could make it work for your case just as well - maybe a bit simpler even. Just copy the formulas and make some changes.

Jay

Thanks for your suggestions, this will help me a lot

Ian

I am just visiting here, but these recommendations have given me a lot of help also. Many thanks.

Charmain Emantel