Date problems when using MS Query

[Guest]

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!

 

[Jack in the UK]

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

 

[Mark W.]

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?

 

[Jack in the UK]

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

 

[Guest]

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

 

[Jack in the UK]

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