Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Date problems when using MS Query

  1. #1
    Guest

    Default

    I am trying to use Word to mail merge date from Excel. For some reason when I try and select on the date field that I have it doesn't recognize it properly. Even if I set the condition IsNotNull, it does not get selected even though there is a valid date there. Also, there is another date field that seems to work ok, except that it shows the date AND time even though I only enter a date. These cells look like they are formatted the same but clearly respond differently in MS Query. Any help on this would be GREATLY appreciated. THanks very much!

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hi

    To be blunt ! Word YUUUUUUUUUCk!

    Can you not do all this in Excel vlookups and so on...

    IF so i might be able to code out such an idea, sorry i hate Word and refuse to use it (just my view nothing personal = it stinks)

    Excel has VAST power that not used i exploit this and run merges as such to on the fly command button run letters, i do this EVERY dat 25 today and same mant days i make coffe and done,,,

    Interested?????

    PS SORRY TO Word lovers.. nothing personal
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-02-25 11:21, Anonymous wrote:
    I am trying to use Word to mail merge date from Excel. For some reason when I try and select on the date field that I have it doesn't recognize it properly. Even if I set the condition IsNotNull, it does not get selected even though there is a valid date there. Also, there is another date field that seems to work ok, except that it shows the date AND time even though I only enter a date. These cells look like they are formatted the same but clearly respond differently in MS Query. Any help on this would be GREATLY appreciated. THanks very much!
    Is it possible that what you believe to be a datevalue is really a text representation (e.g., "1/1/02") of a date?

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    Query should be ODBC daates should be fine if set connert by netwrok profiles....

    thought about this ICT Manager needs to adjust convertions on download, ask them best call


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  5. #5
    Guest

    Default

    Mark

    THere are NO quotes in the date field, so I don't see how it is text. In fact, if I change the format to General, the number changes from 12/30/00 to 36891, so it does look like a correct date. Any ideas?? Thanks again!

    Jeff

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    Sounds like your data is not clean, that s comes in as 01/01 so excel will convert to 10/01/00 automatic

    Need to format the cell to give correct daye reference as general will only offer serial date nuber custon format as you want to read xx/xx/xxxx or what ever.

    Like i said in earlier post ICT manager need to get ODBC to rip the data as you want else your be onverting for ages. ODBC will allow this, i do it everyday repeatedly..

    Good luck


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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