Date Format in a Query Output

[jbesr1230]

Hello,
I query a linked table that has dates in mm/dd/yyyy format. I would like the output of the query to return the dates with month and year only i.e. 11/2004 or Nov-2004 etc. What would be a way to do this? Is there code that I can put in Field Property? Can I nest or concatenate the Functions Month and Year with the expression builder?
Thanks
JBESr

 

[Corticus]

In your query, go to the field where you are pulling date.

I'm going to assume your date field is called [date], adjust as necessary.

Replace the direct reference to the field with an expression, so, where you have this:
[date]
in your query, replace with:
newDate: format([date], "mmm-yyyy")
or
newDate: format([date], "mm/yyyy")

The name 'newDate' is arbitrary, it's simply the column header for this expression field, you can change it to anything (but the name of the referenced field - this creates a circular reference).