How to Convert a Date on Access Query

Microsoft Access is the database application included with the Microsoft Office suite of professional software. While working in an Access database, you can create and run different queries to find certain groups of information. If your Access queries involving date fields are returning results in the improper format, you can modify the query's configuration in order to convert the date records to a different format.

• 1

  Launch the Microsoft Access program on your PC and open the database file that contains your query.

• 2

  Double-click on the name of an existing query on the right side of the window or press the "Query Design" button at the top to create a new one.

• 3

  Open the "Field" drop-down menu in the first column and choose the date field that you want to convert in the query.

• 4

  Place your cursor in the second column.

• 5

  Type "Expr1: =Format()" into the second column. This expression will tell the query that it needs to convert data into a different format.

• 6

  Place your cursor in between the two parentheses at the end of the expression and type in the name of the date field you want to convert, surrounded by brackets.

• 7

  Place a comma after the second bracket and enter the format you want to convert the date to, surrounded by quotation marks.

• 8

  Hit the "Run" icon at the top of the window to save the query and view its results.