View Full Version : Date Formate


amerifax
06-27-2007, 04:31 PM
I tried many ways. The actual date is 05/20/2007

[PERMIT]![PER_DATE]="052003"

Thanks
Bob

motleyjew
06-27-2007, 06:27 PM
Format([PERMIT]![PER_DATE],"mmddyy")

amerifax
06-29-2007, 08:40 PM
I thought to try but have not had much luck since 2000 with 2 digit.

Thanks
Bob