Future Date

I

IS

I am trying to add 6 months to the current day. So Jan 15, 2005 becomes June
15, 2005. Does anyone know how to do this?

Thanks
 
V

Van T. Dinh

Check your maths. Your example is actually adding 5 months, not 6.

Check Access VB Help on the DateAdd() function.
 
E

eyal

1234567890123456789012345678990123456789012345678901234567890123456789012345
6789012345678901234567890123456789011111111111111111111111111111111111111111
1111111111111111111111111111122222222222222222222222222222222222222222222222
2222222222222222222233333333333333333333333333333333333333333333333333333333
3333344444444444444444444444444444444444444444444444444444444444444444444444
4444
 
Top