--- In vantage@yahoogroups.com, "roomurray" <rupert@...> wrote:
That was a lot of 'manipulation's in one sentence, but if I had the word 'manipulation' stored somewhere, I could just change it once and the whole post would change.
Jim Campbell
Database Consultant
>You should never use a field to store data which is a manipulation of another field. Any time the manipulation is required you should simply apply the manipulation to the base data.
> I'm looking to create fields (Date01 etc) with a number of modules based on the data held in other date fields.
>
> one is +1 year one is + 4 weeks. What is the best method to carry this procedure out?
>
That was a lot of 'manipulation's in one sentence, but if I had the word 'manipulation' stored somewhere, I could just change it once and the whole post would change.
Jim Campbell
Database Consultant