LeighWardle
asked on
Formatting date output by an MS Access Query
Hi Experts,
I'm using Access 2016.
My tables have some fields that are of type: Date/Time.
I am creating a query that currently outputs the date in the form: 22/12/2018.
How can I output it in the form: 22 December 2018?
Regards,
Leigh
I'm using Access 2016.
My tables have some fields that are of type: Date/Time.
I am creating a query that currently outputs the date in the form: 22/12/2018.
How can I output it in the form: 22 December 2018?
Regards,
Leigh
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry crystal - I did not see your answer until I had awarded points to Anders.
ASKER
It turns out that you can use a Custom data format for that property.
"d MMMM yyyy" gave me the output I wanted.