Link to home
Start Free TrialLog in
Avatar of LeighWardle
LeighWardleFlag for Australia

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
ASKER CERTIFIED SOLUTION
Avatar of Anders Ebro (Microsoft MVP)
Anders Ebro (Microsoft MVP)
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of LeighWardle

ASKER

Thanks, Anders.

It turns out that you can use a Custom data format for that property.
"d MMMM yyyy" gave me the output I wanted.
Sorry crystal - I did not see your answer until I had awarded points to Anders.