setting all dates for table and queries to short date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Recordset Findfirst Date Issue 0
A03- Date format in tables? 1
Date format in Query 1
Date format when exporting 2
Datepicker issue after changing Windows' short date time format 5
Automate Change of the format of a field to short date for export 2
Automatically set the data type as date for a Make Table Query 3
Stored date is not being recognised 1

Back
Top