Date Calculations

[Calantha]

Hello,

I would like to do a date calculation where I take a start date and add 46 weeks onto it to find out the end date.

No matter what I do seems to return a completely wrong value (year 0061 for example).

How can I add weeks onto a date and is it possible?

[RalphL]

Dates are number of days. Therefore to add 46 weeks you need to add 322 days. NewDate = OldDate + 322.

Edited August 22, 2005 by Guest
Omission

[Calantha]

I realized what my issue was... My start date field was a text field so it was getting all crazy.

Thanks though!

[Calantha]

But... I have another question.

If my date field is formatted "Friday, September 01, 2005" how come when I reference the field via <> it appears 09/02/05?

[Calantha]

Nevermind, it works now. But stops working and then starts again off and on. Hmmm... Oh well.

[-Queue-]

Formatting applies only to a particular instance of a field on a layout. The data in that field does not change. For a date merge field to display as desired, it must be formatted as well. If it is contained within a text block, then right-click on the text block and select Date Format, which will format all date merge fields within it in the same manner.