Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

File Maker Pro 9 thread295-1400681

Status
Not open for further replies.

alf1965

Programmer
May 14, 2008
3
US
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!




 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top