How do I Add 14 Days to a Given Date in MM-DD-YYYY

# Thread: How do I Add 14 Days to a Given Date in MM-DD-YYYY

1. Senior Member
Join Date
Dec 1969
Posts
102

## How do I Add 14 Days to a Given Date in MM-DD-YYYY

I have a Date from the User&#039;s Input and the End Date cannot be greater than 14 days after the Start Date.<BR><BR>I have found lots of examples in FAQ about adding and substracting on Now(), but none on a given date.<BR><BR>How do I calculate 14 Days after a Given Date?<BR><BR>Thanx,<BR>Lou

2. Member
Join Date
Dec 1969
Posts
33

## RE: How do I Add 14 Days to a Given Date in MM-DD-

3. Senior Member
Join Date
Dec 1969
Posts
102

## NO.. Not from NOW, From a Entered Date

Perhaps you didn&#039;t understand.<BR><BR>The User Puts in a Start Date and an End Date. The Dates cannot be more than 14 Days Apart. The Start and End dates can be *Any* Date.<BR><BR>How can I do this?

4. Member
Join Date
Dec 1969
Posts
33

## RE: NO.. Not from NOW, From a Entered Date

5. Senior Member
Join Date
Dec 1969
Posts
1,843

You would want to use DateDiff for this purpose. Read about it here: <BR><BR>http://www.ultimateasp.com/functions/default.asp?ASPFunction=DateDiff&go.x=4&go.y=10

6. Senior Member
Join Date
Dec 1969
Posts
102

## I have tried with No LUCK....

I have tried to use DateAdd and DateSerial to add 14 Days to the date, but I still get a "Type MisMatch".<BR><BR>The Dates are in both YYYYMMDD and MM-DD-YYYY. When I separate out the parts to add to the Day, I think the parts go to Char.<BR><BR>Can I use one of the formats that the Dates are already In with the DateAdd or DateSerial?

7. Senior Member
Join Date
Dec 1969
Posts
1,843

## See my post above

You can use DateDiff here to find the interval. Before you can use DateDiff, you might have to convert the date to a VB Date Format by using CDate(yourdate).

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•