• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 138
  • Last Modified:

Calculate Dates

Hi, does anyone know how to calculate the date from an existing date after 4 weeks?
For instance,
I have a existing date, 4/6/2003, after 4 weeks(28 days), what will be the new date?
Does anyone have a solution for this?

Thank you very much.
0
bobubi
Asked:
bobubi
1 Solution
 
TimCotteeCommented:
Hi bobubi,

Use:

dteNewDate = DateAdd("d",28,dteOldDate)

Tim Cottee MCSD, MCDBA, CPIM
http://www.timcottee.tk 

Brainbench MVP for Visual Basic
http://www.brainbench.com

Experts-Exchange Advisory Board Member
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now