D dogman01 Registered User. Local time Today, 15:02 Joined Dec 3, 2008 Messages 47 Jan 5, 2009 #1 I have a short date field but I would like to format a seperate text box that will only display the last 2 digits of the year. ie: 01/05/2009 = 09
I have a short date field but I would like to format a seperate text box that will only display the last 2 digits of the year. ie: 01/05/2009 = 09
pbaldy Wino Moderator Staff member Local time Today, 12:02 Joined Aug 30, 2003 Messages 36,272 Jan 5, 2009 #2 Try =Format(DateField, "yy")
