Insert Current Year in a field from a form

[clloyd]

I have a form that when you hit a command button it moves the current year value (could be three years prior) to a previous year field. I need code to insert the current year in the current year field. I know this has to be simple but I just can't get it done.

[clloyd]

I have a form that when you hit a command button it moves the current year value (could be three years prior) to a previous year field. I need code to insert the current year in the current year field. I know this has to be simple but I just can't get it done.

I got it

 helpfield = DatePart("yyyy", Now())

[NeoPa]

Now() is fine, but Date() is probably the one you'd need.

Your code returns a string. The following returns the number. If putting into a TextBox control it would matter of course.

helpfield = Year(Date())