File Maker Pro 9 thread295-1400681

[alf1965]

Question referencing previously closed post:
thread295-1400681

The original question was is there a way to get the dates in between a date start and date end fields. The response was great and demonstrated how to get the results to show up in a field as a list. I was wondering how to take it a step further- I'd like to take the results and insert a row for each result that inserts all same data from row for each new date calculated.
Example:
id: 1
start date: 11/5/2007
end date: 11/10/2007
catagory: Ror
nights: 5
So the database will show all of the above plus each date in the range something like:
Row 1
id: 1
start date: 11/5/2007
end date: 11/5/2007
catagory: Ror
nights: 5
Date 1: 11/5/2007
row 2
id: 1
start date: 11/5/2007
end date: 11/5/2007
catagory: Ror
nights: 5
date 2: 11/6/2007
row 3
id: 1
start date: 11/5/2007
end date: 11/5/2007
catagory: Ror
nights: 5
date 2: 11/7/2007
and so on and so forth and also have the ability to delete the rows as the date range changes.

How could I modify the script to do that?

Thanks for your help!

 

[JeanW]

It is not a script, it is a Custom Function.

You need a calculation field to parse out each row from the returned value and add the fields you want, separated by a ¶.

Or you could use a recursice calculation if you first store how many rows the CF returns and concatenate your fields.