Date Function (Not recognizing days in month)

[TallMan]

Guys,

I am having trouble with a date function.

Currently I am using:

If Day(Date) + 7 < 8 then

code code code

else

code code code


As I write this post on the 25th of November, the number coming back is equal to 32.

How do I tell it to remain in "month ranges"

What I need is for the function to recognize that 7 days from now would be the first of November so that it returns a "1"

Thanks in advance!

 

[boblarson]

Use DateAdd function:

If Day(DateAdd("d", 7, Date))< 8

 

[TallMan]

Worked like a charm! Thanks Bob!

 

[boblarson]

Now that I read it again you probably would have been fine with the other had you used the calculation INSIDE the Day function:

If Day(Date + 7) < 8 then

 

[TallMan]

Interesting. Thanks for the additional info.