Date format in query

  • Thread starter Thread starter Les
  • Start date Start date
L

Les

I would like to display the zeros in a date within my query. The date field
format is set to dd/mm/yy and I want to see an output like 01/01/04 is there
a way to do this?

Les
 
Les,

Open the query in design view, place the mouse pointer in the design grid
below the date field and right-click Select Properties, and set the format
settings like you did in the table.

HTH,
Nikos
 
Nikos

Thanks for that

Les
Nikos Yannacopoulos said:
Les,

Open the query in design view, place the mouse pointer in the design grid
below the date field and right-click Select Properties, and set the format
settings like you did in the table.

HTH,
Nikos
Click to expand...
 
thanks for that

LES
Nikos Yannacopoulos said:
Les,

Open the query in design view, place the mouse pointer in the design grid
below the date field and right-click Select Properties, and set the format
settings like you did in the table.

HTH,
Nikos
Click to expand...
 
Back
Top