Results 1 to 4 of 4
  1. #1
    vessellcpa is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    2

    Date columns linked to AS400 table not formatted as dates

    I have a table linked to an AS400 table and created a query to use as a basis for some reports. The problem is the AS400 table does not have a date column (field), but rather has 4 separate fields, one representing the century, "DATCC", one representing the year, "DATYY", one for the month, "DATMM", and the 4th representing the day, "DATDD". How can I combine the four fields into one that can be formatted correctly as a date field in Access? I'm new to Access and not familiar with SQL at all. Any ideas?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Look into the DateSerial() function.

  3. #3
    vessellcpa is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    2
    Thanks, that was exactly what I needed.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Glad we could help.

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

Similar Threads

  1. Replies: 2
    Last Post: 10-27-2009, 07:09 AM
  2. Replies: 0
    Last Post: 07-27-2009, 07:51 AM
  3. Count Dates within Date Range
    By eckert1961 in forum Queries
    Replies: 2
    Last Post: 03-08-2009, 10:58 AM
  4. Replies: 0
    Last Post: 02-21-2008, 09:52 AM
  5. Displaying data formatted
    By Zoroxeus in forum Forms
    Replies: 0
    Last Post: 03-14-2006, 09:45 PM

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