formatting the date field

  • Thread starter Thread starter sheela
  • Start date Start date
S

sheela

Hi,
I have a table with some date fields with the format
mm/dd/yyyy.
I need to generate a table from a query having the date
fields' format as mm/dd/yy.
How do I get the results in the required format (mm/dd/yy).
It is okay even changing the format in the original table.
I tried to change it in the design of the table, by
changing the field's format set to short date, but that is
not working.

Thanks in advance for your help.
sheela
 
I've just tried this on a table with the date entered in
the dd/mm/yyyy format:

Goto Query Design and select the field that contains the
date. Right-click on the field name and choose Properties.
The Field Properties box should now be displayed. Enter
the format as dd/mm/yy and run the query. The date should
be displayed as you want.
To change the format in Table Design enter the format as
dd/mm/yy rather than selecting short date.
 
Back
Top