setting all dates for table and queries to short date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tymarose - 23 Jul 2007 18:46 GMT

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.

Reply to this Message

Jackie L - 23 Jul 2007 18:58 GMT

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

> 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.

Reply to this Message

John W. Vinson - 23 Jul 2007 22:18 GMT

>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.

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]

Reply to this Message