Default to Current Year only (1 Viewer)

[MikeG]

I would like to be able to default my Curr_Yr field without showing it on a form, thus eliminating interaction by the data entry operator. If there a way to do that via the default value entry? I'll need it later for reports, etc...plus it's part of a multiple key field. I've searched on all the date/year wording variations here that I can think of but couldn't find much help. Any help is greatly appreciated!

 

[FoFa]

In the default for that field, try
=YEAR(date())

you can format also if you wish. You can make the field invisible if you do not want them to see it.

 

[DJN]

Put =DatePart('yyyy',Date()) in the Default Value property of the Curr_Yr field. If you don't want you users to 'fiddle' with the date, change the Locked property of the field to yes.


David

 

[MikeG]

OUTSTANDING!! Works like a charm!
Thanks again!

mg

 

[hootie318]

I just want to have the last two digits of the current year. Anyone have anything for that?

 

[fuzzygeek]

I just want to have the last two digits of the current year. Anyone have anything for that?

=Mid(DatePart('yyyy',Date()),3,2)

 

[hootie318]

Works like a charm. Thanks a ton!