Dates

Hi Kate

Thank you for your question. Try this and see if it produces the results you are looking for:

Select your query and switch to design mode.
Clicking in the next free column in your query, in the Field row, give your new column a title eg short_date

add in a colon followed by the name of the exisiting field that contains the date you would like to reformat. So the full Field title for your new column becomes

short_date: [date]

where date is the name of the field you would like to reformat.

Press the enter key to commit the change then right click on the new field name you just entered and from the short menu choose Properties.

In the properties sheet that appears type in dd/mm/yyyy and press the enter key.

You can close the Properties sheet and run your query using the exclamation mark on the ribbon.

You should find your new field appears displaying the originaly date value but in your shorter date format.

I hope this helps - do let us know if you have any further questions.

Kind regards,
Andrew