Date Range Relationship v6 Part II

[Jake Sterling]

This is a more complex version of the problem of creating a relationship based on ranges of dates. I got a great solution from my last request for help on this problem, maybe I

[Ender]

Hi Jake,

To make AND conditions in relationships with FM5/6, you need to build the keys by concatonating the conditions into one line in the field. OR conditions are made from multilines. To do both, you use both.

Smart Ranges uses multilines to create the OR conditions for each chunk of the date. To add your AND conditions to the Smart Ranges key, you need to add the additional conditions to each line of the Smart Ranges key. This is easily done by using a substitute() function to replace each "