In Filemaker I use a Date plugin to automatically create a series of dates from a given start date to a given end date and return a list of dates in a text field separated by returns. For example a start date of 1/1/2004 (UK date formats) and end date of 5/1/2004 will return:
1/1/2004
2/1/2004
3/1/2004
4/1/2004
5/1/2004
I can then use a relationship from another file which will match a single date or even another list of dates produced in the same way against any of the dates contained in the above calculation (i.e. if any date matches any date the relationship has a match) - very useful in booking systems etc.
I cannot work out how to do the same thing in Servoy - is it possible? I have tried playing around with text fields and manually entered lists of dates but cannot get a relationship to achieve a match unless the entire contents of the field match. Do I need to use an array - if so, how?