I'm wondering if it is possible to have a repeating date field and have it calculate dates based on the value from another field.

Basically I want to have the repeating date field create a schedule based upon the start date of a treatment. so if the start date is 1/1/2000 then 15 dates are calulated in one repeating date field. make sense? Any help is greatly appreciated.

email is [email protected]

thanks again

------------------

quote:

---

Originally posted by danny:

I'm wondering if it is possible to have a repeating date field and have it calculate dates based on the value from another field.

Basically I want to have the repeating date field create a schedule based upon the start date of a treatment. so if the start date is 1/1/2000 then 15 dates are calulated in one repeating date field. make sense? Any help is greatly appreciated.

---

You can do it via a script. With 15 Set Fields.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Senior Filemaker Developer

http://www.database-resources.com

mailto:[email protected]

=-=-=-=-=-=-=-=-=-=-=-=-=

quote:

---

Originally posted by captkurt:

You can do it via a script. With 15 Set Fields.

---

Thanks. Can it be done without defining set fields?

You're not defining "set fields", you'd be creating a script which sets each repetition to a date based on the first repetition.

Frankly (and I'm surprised Kurt didn't mention this), repeating fields are generally a pain in the neck, and you'd probably be better off with either a relationship setup or with different date fields (with the dates calculated based on the "StartDate" field), just because it's more flexible that way.

I know, it gets more complex at first, but really, you'll thank yourself down the road.

Dan

quote:

---

Originally posted by danjacoby:

You're not defining "set fields", you'd be creating a script which sets each repetition to a date based on the first repetition.

Frankly (and I'm surprised Kurt didn't mention this), repeating fields are generally a pain in the neck,

---

I would have mentioned this (I cannot stand to use repeating fields) but I forgot!

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Senior Filemaker Developer

http://www.database-resources.com

mailto:[email protected]

=-=-=-=-=-=-=-=-=-=-=-=-=

quote:

---

Originally posted by danjacoby:

You're not defining "set fields", you'd be creating a script which sets each repetition to a date based on the first repetition.

Frankly (and I'm surprised Kurt didn't mention this), repeating fields are generally a pain in the neck, and you'd probably be better off with either a relationship setup or with different date fields (with the dates calculated based on the "StartDate" field), just because it's more flexible that way.

I know, it gets more complex at first, but really, you'll thank yourself down the road.

Dan

---

Could you elaborate here a bit more my attempts at getting similar secenario to work have failed to date.

I'm trying to create an open modification history based uppon modified dates and a seperate record Id.