Value list limited by date

[chlowden]

Hello. I am a newbie who has, I presume, a simple question. My db has a value list with a list of over 600 projects from another table. To avoid having all the projecs listed, I wish to limit the list to last 6 months via the creation date field in the projects table. I presume this is possible ... my question is how?

[mr_vodka]

You can have an unstored calc on the parent side Let ( d = Get ( CurrentDate ); Date ( Month (d) -6 ; Day (d); Year(d) ) )

Then a ' ≤ ' join can be used between this unstored calc and the creation date field for your projects table. (You may want to use another table occurrence instead of your current projects table occurence)

Now in your value list, make sure that you use the option to show only related values.

[chlowden]

Thank you