A aervin5 Registered User. Local time Today, 14:27 Joined Nov 14, 2006 Messages 11 Nov 21, 2006 #1 Does anyone know the expression for putting a date in the format "MMDDYY" without any /'s? In Excel, this can be accomplished with Month() & Day() & Year(). Thanks! Andy
Does anyone know the expression for putting a date in the format "MMDDYY" without any /'s? In Excel, this can be accomplished with Month() & Day() & Year(). Thanks! Andy
Matt Greatorex Registered User. Local time Today, 14:27 Joined Jun 22, 2005 Messages 1,019 Nov 21, 2006 #2 Format(date,"MMDDYY")
A aervin5 Registered User. Local time Today, 14:27 Joined Nov 14, 2006 Messages 11 Nov 21, 2006 #3 Thanks Thanks a lot!