DateAdd

[NFLDUser]

I am using DateAdd but causing problems when I change to another month. Any ideas on how to get this to work?

I am looking to just find a way to add a day to a specific date, but for it to automatically go to the next month if necessary ... and I am stumped!


updateDay (100, Format(DateAdd("d", 1, monthControl.Date), "MM/DD/YYYY"), ctMDay2)


Thanks!!!

 

[RonRepp]

Simply Put:

Dim ThisDate as Date

ThisDate = DateAdd("M", -1, Now)''this returns one month ago

ThisDate = DateAdd("W", -1, Now)''this returns one week ago

ThisDate = DateAdd("D", 1, Now)''This returns tomorrow's date.

ThisDate = DateAdd("D", -1, Now)''This returns yesterday's date.

I hope this helps

Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.

 

[Golom]

Your example should do that.

If "monthControl.Date" is the last day of a month then "DateAdd("d", 1, monthControl.Date)" will return the first of the following month. Is that not what's happening?

 

[NFLDUser]

Sorry, yes that was right.

My problem was a few lines beyond this.