Problem with "ww" edits

[mpetersen]

I'm working on editing a private subroutine and have run into some trouble. What I would like to do is edit the auto populated date which is written into a .dot file. I thought I had found the location in the code where I needed to edit this but when I make the change I don't get a new result, that is the document that is created maintains the same date (every 4 weeks) rather than updating to the new date (every 2 weeks). This is the code I think I need to edit:

stBookmarks = stBookmarks & "NextContact=" & Format(DateAdd("ww", 4, Date), "mmmm d, yyyy") & ";"

I changed the 4 here to a 2 but that didn't solve the problem. What am I missing? Does this need to be edited somewhere other than the VBA for the particular form I'm working in?

Thanks!

 

[KenHigg]

The way I debug something like this is to pull it apart and add pcs back into it till it breaks, then you'll be close to the trouble part. So first do something like:

stBookmarks = Date

If it works, try:

stBookmarks = DateAdd("ww", 4, Date)

etc...

 

[mpetersen]

thanks, that worked. I stripped out the addressee info that preceded it and worked from there. all set now!

Thanks!