Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

Date field between AS400 and MS-ACCESS

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Date field between AS400 and MS-ACCESS

    I have created a MS-ACCESS table which is linked to AS400's database through IBM ClientAccess ODBC driver, and a field of the file in AS400 defined as date field ( DDS datatype 'L' and specified DTEFMT keyword *ISO ). I was trying to do following things but failed to get the query result. 1. Sort the table by the date field. 2. Using parameter prompts, 'from' and 'to' date, and use them to select data within the date range. Does that means, the date type in MS-Access and as400 does not comply with each other? Please someone give a explanation. Thanks.

  • #2
    Date field between AS400 and MS-ACCESS

    Yes, the dates on the 400 and Access are different animals. The best way to compare dates would be with an SQL statement like this: select * from myfile where datefield between '01/01/1999' and '12/31/1999' the 400 will always recognise this string literals above as dates. If your format in windows is set to MM/DD/YYYY then you can use the following quick conversion, cstr(DateV) to convert a date to a 400 friendly string Hope this helps Howard www.sqlthing.com

    Comment

    Working...
    X