Adding to a Date

[coffeec]

I have an date field that I want to be able to add a number of days to it. I want to be able to add 20 days to a date field. What kind of script would be used here to accomplish this? I tried adding the number straight to the date field and set the calulcation to return as a date and get some really weird results. There must be an easy way to add to a date field.

Thanks in advance, Coffee.

[mr_vodka]

Is your original date properly formatted as a Date field? If the original field, StartDate is formatted as a Date field, you can have a calc field with StartDate + 20, and if the result is formatted as a Date field, it should give you what you are looking for.

[coffeec]

I do have a date field but I have another field for expected delivery period that has a numeric value in it. I have setup the expected delivery date filed as a calculation to add the order date field with the expected delivery period field. This is not producing the results I need. Some dates have years going to 2881 and some records have a ? mark. Wierd.

[mr_vodka]

Even if your calc field is OrderDate + DeliveryPeriod, it should yield you the proper results.

The year coming weird like that is usually a result of the OrderDate field being a Text field etc. Again are you sure that OrderDate is properly formatted as a Date field as well as the calcualtion result and the DeliveryPeriod field a number field?

[coffeec]

Yes you are right, my order date field was a text field that was auto entering a creation date. Thanks for your help.