Results 1 to 3 of 3
  1. #1
    dollygg is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jul 2009
    Posts
    45

    date format

    My Code:

    Recon_list.Recon_Date=#" & Month(fieldrecondate) & "/" & Day(fieldrecondate) & "/" & Year(fieldrecondate) & "#"

    My quesiton:

    Would that causing problem in Poznan where the system date is "dd/mm/yy"? The recon_date is displayed as "dd/mm/yy" format in the recon_list table in Poznan. It's displayed as "mm/dd/yy" in my computer because I have a different system date format.


  2. #2
    dollygg is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jul 2009
    Posts
    45
    Dates in SQL must be written in the US date format (month/day/year). This is imperative regardless of the default date format settings on your computer. The Access query design window accepts dates in your local default format but it converts the date you type to the correct format when it builds the SQL statement.

  3. #3
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    So is this thread Solved yet? If so then follow the link in my sig to mark the thread as Solved.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Convert date format yyyymmdd for datediff
    By TEN in forum Programming
    Replies: 1
    Last Post: 06-17-2009, 09:35 PM
  2. Access VBA - date format conversion
    By benattal in forum Programming
    Replies: 3
    Last Post: 12-22-2008, 10:40 AM
  3. Date Format
    By wasim_sono in forum Forms
    Replies: 2
    Last Post: 08-15-2006, 01:20 AM
  4. Replies: 0
    Last Post: 07-24-2006, 06:31 AM
  5. Date Format
    By St3ph3n in forum Access
    Replies: 4
    Last Post: 03-09-2006, 11:23 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums