Calculating Dates

[Ckelly]

Hi

I wish to define a field that calculates a date taken from two drop down lists - one containg numbers, the other containing periods (e.g. day/s, week/s, month/s).

For example, if today's date is 17/3/3 and a user selects 2 weeks, the calculated field returns 31/3/3.

Any idea on how this might be achieved?

Thanks in advance.

[Lee Smith]

Take a look at Russ Baker's Handy Bits in the sample file area of this lists.

In the date calculations there is a calculation for doint this.

HTH

Lee