Hello,

I would like to take the next week's date( for example next Monday)
from an ActiveX in a DTS package. Can I do that and how?

Thanks in Advance

Riri

Next weeks date and do what exactly? I'm not real clear on
what you need to do but maybe your are looking for some of
the date functions. You can use DateAdd to add a week to an
existing date.

-Sue

On 8 Feb 2005 08:10:12 -0800, eleftheriak (AT) hotmail (DOT) com wrote:

FormatDateTime(DateAdd("ww", 1, Now()),2)

should give you the date one week from now. You can pass that back and
forth from a global variable that you create in the package with:

DTSGlobalVariables("< variable name>").Value = FormatDateTime(DateAdd("ww",
1, Now()),2)

<eleftheriak (AT) hotmail (DOT) com> wrote