Prev: Append only new records/entire record makes unique identifier
Next: Query results where gaps exist Min & Max do not work
From: LoriP on 12 May 2010 13:04 Thank you for the quick answer. I was just not sure what to search for and this got me aimed in the right direction. "Chris" wrote: > Hi, > > Go to online help and look for DATESERIAL function. I think that should > help you out. > > "LoriP" wrote: > > > I need to calculate many fields based on one start date and I need the > > calculations to count by month. > > For example first visit is 4/25/2010 > > The first calculated field must be 5/25/2010 +/- 7 days > > This is the first time I've had to do a calculated field where the next > > visit must be the exact day of the next month and not just the generic "30 > > days" Is there an easy way to do this? > > Thank you > > Lori |