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,923
    Look into the DateSerial() function.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  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,923
    Glad we could help.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

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