Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17

Query on Date (M/D/YY) field seems to be ignoring YY

  1. #16
    C Muth is offline Novice
    Windows 10 Access 2007
    Join Date
    Jun 2019
    Posts
    12
    Thanks will try to concatenate the #. I am good with storing data as either numbers or text - whichever works. As the source table is via ODBC, I can not change. The only workaround I know would be to create an non ODBC table with a date formated field and write a delete / append query - which I am better off posting in a separate thread.

  2. #17
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    6,452
    Yes you could, and use that table (or a query using the same technique to construct a date). What you need to consider is, what are the chances that any ODBC date data can be altered? If that ever happens, your calculated date is out of sync. Probably better to stick with calculating on the fly - even if your query (instead of a table) uses a function call to perform the concatenation.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Append Query not ignoring primary key
    By Robyn_P in forum Queries
    Replies: 7
    Last Post: 06-05-2018, 06:58 AM
  2. Replies: 3
    Last Post: 06-04-2017, 01:02 PM
  3. Replies: 7
    Last Post: 05-27-2015, 12:45 PM
  4. Replies: 2
    Last Post: 04-13-2014, 06:55 PM
  5. Yesterday's Date ignoring weekends
    By coletteabrown in forum Access
    Replies: 4
    Last Post: 12-09-2013, 08:02 AM

Tags for this Thread

Posting Permissions

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