We recently updated our
Terms and Conditions for TechRepublic Premium.
By clicking continue, you agree to these updated terms.
Invalid email/username and password combination supplied.
An email has been sent to you with instructions on how to reset your password.
Welcome to TechRepublic!
Username must be unique. Password must be a minimum of 6 characters and have any 3 of the 4 items: a number (0 through 9), a special character (such as !, $, #, %), an uppercase character (A through Z) or a lowercase (a through z) character (no spaces).
Bring up your table that contains the date you are wanting to format-view the table in “datasheet” view. Select your date field under the column “field name” and then select to the right of the column, under Data type, select from the drop down window “Date/time”. Next, on the bottom of your screen will be another section thus allowing you to format this field even more. Under the general tab, in the format section, click in the box on the right, then select from the drop down window “short date” and save the changes to your table. Problem fixed.