Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002
    Posts
    173

    Unanswered: formatting date in a query

    How would I format a long date to be presented as a short date in a query. Right now it's showing dates as "11/01/2002 4:00PM" but I need to format the query to show it simply as "11/01/2002".

  2. #2
    Join Date
    Aug 2002
    Location
    Northampton, England
    Posts
    266
    Create a calculated field in the query grid as Date:Format([FeldName],"dd/mm/yyyy") or create an update query to change all the records to that format.

    David

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •