A amerifax Registered User. Local time Today, 08:27 Joined Apr 9, 2007 Messages 304 Jun 28, 2007 #1 I tried many ways. The actual date is 05/20/2007 [PERMIT]![PER_DATE]="052003" Thanks Bob
motleyjew Registered User. Local time Today, 09:27 Joined Jan 11, 2007 Messages 109 Jun 28, 2007 #2 Format([PERMIT]![PER_DATE],"mmddyy")
A amerifax Registered User. Local time Today, 08:27 Joined Apr 9, 2007 Messages 304 Jun 30, 2007 #3 oK I thought to try but have not had much luck since 2000 with 2 digit. Thanks Bob