Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Field to Display year

Status
Not open for further replies.

cmorales

Instructor
Oct 18, 2002
22
0
0
US
need a little guidance.
I would like to create a date field that creates year only (2004) and automatically changes to 2005 to reflect new year. I'm sure this is pretty simple but I cannot figure it out
 
cmorales
In the design view for your table, add a field called something such as MyDate, and in the Format property put yyyy. That will extract the year only from the date that is entered.

Tom
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top