Date + 30

How do I add 15 days to a date?
It appears to me that date are strings? so the dDate = dDate + 15 does not work.

Thanks,

Paul Ziegler

I found it. Took me awhile, but I think I have the best way.

dDate..Day+=15

Paul,

Like this

dDate is date

Add 15 days

dDate = dDate..day + 15

Add 2 months

dDate = dDate..month + 2

Add 2 years

dDate = dDate..year + 2

Carlo,

Thanks. It was very helpful. My brain in trapped in the my old design tool way of thinking and sometimes it takes awhile to find the answer in the help.

Paul

Paul,

Also remember that to do the date arithmetic it has to done as variables such as shown in Carlo's examples.

Milton

Carlos,

This does not seem to work.

dDate is Date //dDate takes on the value 20090227
dDate = dDate..Day + 15 //dDate now shows the value 18000211

This works.

dDate is Date
dDate..Day+=15 // dDate now shows the value 20090314

I am using WD12. What am I doing wrong?

Paul

Quote
Paul Ziegler
Carlos,

This does not seem to work.

dDate is Date //dDate takes on the value 20090227
dDate = dDate..Day + 15 //dDate now shows the value 18000211

This works.

dDate is Date
dDate..Day+=15 // dDate now shows the value 20090314

I am using WD12. What am I doing wrong?

Paul

Hi Paul,

dDate = dDate..Day +15 // dead wrong !

think dDate..Day equals 10
then add 15 equals 25
and then you're setting the full date to 25 ! This will not work ..
Regards,
Guenter

Guenter,

Thanks for the reply. Then I assume the correct way to add 15 days to a date is:

dDate..Day+=15

This gives me the desired result. Is there another, or better way of doing this?

Paul

Like the help file says:

// Example on an item
Work.StartDate = "20011225"

// Add 5 days to the date
Work.StartDate..Day += 5 // this ADDS 5 days to the date

// Modify the days
Work.StartDate..Day = 10 // this CHANGES the day to 10

The following arithmetic operators can be used by Day:

++ and --

+= and - =

StartDate is date = "20041126"
StartDate..Day++ // Add 1 day to the date
StartDate..Day+=5 // Add 5 days to the date
StartDate..Day-=5 // Subtract 5 days from the date

David,

Thanks for the reply. I am set now.


Paul

Another thing that works always:

date = integertodate(datetointeger()+30)

Erik

Erik,

Thanks for the response.

Paul