date() + 12 months

[jamesmills]

Hey hows it going
I would like to set a default value
i would like it to be 12 months from the current date

any advise please

thanks

 

[jason246day]

This will add one year to the current date. There you can add days, years, months by changing the field that is currently yyyy.

DateAdd("yyyy", 1, Date)

 

[jamesmills]

dont quite understand what you said?
i tried to put it into access and change a few things but it came up with error.....

So if i wanted to add one year (12 months) onto todays date i would.....?

 

[jason246day]

DateAdd("yyyy", 1, Date)

 

[jason246day]

sorry, left somthing out

TextBox = DateAdd("yyyy", 3, Me.Servers_PurchaseDate)

 

[jamesmills]

right but can i not put it in the default section without having to put it in the VB code bit....

in the defalut bit for todays date i put Date()....
like that?

 

[jdegeorge]

try = DateAdd("yyyy", 3, Date)

Jim DeGeorge

 

[jamesmills]

nope not working?

adding '= DateAdd("yyyy", 3, Date) ' to default vaule of a date feild in a table

 

[jdegeorge]

Well, a default of "=Date()+365" will give you 7/29/2004 because of leap year, so that's not 100% accurate but it's close. Use it for now and maybe I can figure out something or one of the local wizards around here will figure it out. Good luck.

Jim DeGeorge

 

[jamesmills]

ok will do thanks

 

[jdegeorge]

This works...

=DateAdd("yyyy",1,Date())

I don't know what the "3", I got that from Jason's post. And I left out the () after "Date", which normally you don't need.

Jim DeGeorge

 

[jamesmills]

sorry bro but it is still not working on mine?

=DateAdd("yyyy",1,Date())
i had tried it with the () after the date befor..... says it is missing an operator?

 

[jamesmills]

ok it works now...... sorry just me being a fool..... thanks again

 

[jdegeorge]

Glad to have helped! Have a nice day.

Jim DeGeorge

 

[jason246day]

I put this code in the onCurrent event of a form:

Text304 = DateAdd("yyyy", 1, Date)

And when I viewed the form, the box contained the date, one year from today. So it looks like you need to use this code in a module, rather than using it as a source for a textbox. But you can set it as the source for a textbox inside a module, which is what I have done above.

 

[jdegeorge]

Jason

It worked fine as the DEFAULT of the form's text box. Why the extra effort of a module?

Jim DeGeorge

 

[jason246day]

I thought it wasn't working like that, so I was giving him another option. But I guess I just misunderstood.

 

[jamesmills]

:S it worked for e as jdg said?

 

[jamesmills]

no worries..... works great now anyway... thanks all