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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date Formatting

Status
Not open for further replies.

cayden2007

Technical User
Mar 19, 2007
22
US
I need to format a date field on a form to this:

yymm

I need that to automatically show up it is a new record, and I don't know how to format it like that.

Can someone help me?
 
I dont know if you are using a label or txtbox but the data string is:

=Format(Date(),"yymm")



'Life is what happens to you while you are busy making other plans' John W. Lennon 1940-1980
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top