setting all dates for table and queries to short date

T

tymarose

I have it set as short date in the table, but it shows as a long date with
time when i go to the query.
 
J

Jackie L

To format a date field in a query, create a new field similar to the following:
DateFormat: Format([DateField],"Short Date") or
DateFormat: Format([DateField],"mm/dd/yy")

Hope this helps
 
J

John W. Vinson

I have it set as short date in the table, but it shows as a long date with
time when i go to the query.
Click to expand...

Shouldn't make ANY difference.

A Date - regardless of format - is stored as a Double Float number; the
integer part is the number of days since December 30, 1899 and the fractional
part is the fraction of a day since midnight.

If you're displaying the data on a Form or Report, use a textbox with whatever
date format you like. If you're displaying the data in a query datasheet...
well, don't; that's not their purpose! But you can set the Format of a query
field if you wish.

John W. Vinson [MVP]
 
Top