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...
 
You must log in or register to reply here.

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

date field 4
Access Count dates within a Month 4
Access Getting Month periods to show in ACCESS query as 0 when there is no data for the month 0
Stumped By Dates 4
Date problem 5
Passing a UK Date to SQL statement as criteria 2
Format Current Date 3
Excel is changing date format incorrectly 7

Back
Top