Access 2013 Query Question - Convert Date Value to YYYY-MM Format in Query Results

[RHONDAK72]

Hi. I use MS Access 2013. I have a table the includes a date field. The format is Date/Time and dates are displayed in the field as mm/dd/yyyy (e.g. 01/31/2015) I want to be able to query on this field, but I want the query to return the YYYY-MM value for each date. For example, for date 01/31/2015, I want it to return 2015-01 in my query results. Is there an easy way to write an expression within Query Design View in order to get this result?

Thanks,
Rhonda

 

[Joe4]

Sure. It will something like:

MyExpression: Format([DateField],"yyyy-mm")

 

[alansidman]

Here is a SQL Statement for that field only

SELECT Format([Field6],"mm-yyyy") AS Date3
FROM Sheet1;

 

[RHONDAK72]

Thanks so much, everyone!