Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2014

    Unanswered: Pass-Through Query to DB2

    I am having trouble with pulling data from DB2 filtering by date.

    What are my options for date?

    I try using the following:
    WHERE mytable.datefield > Date()+15
    WHERE mytable.datefield > 2015-1-1
    WHERE mytable.datefield > 2015-1-
    WHERE mytable.datefield > #2015-1-1#

    Nothing is working. Got any ideas?

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    if you are using a pass through query to connect to DB2, then use DB2 compliant SQL, not MS Access/JET ....
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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