CDate fails append query Access 2003

  • Thread starter Thread starter CatScratch
  • Start date Start date
C

CatScratch

I have a simple append query where I CDate([DOB]) into an existing
table. Coming in DOB is TEXT. Values coming in are 10/10/1990 etc.

When I look at DOB coming in using IsDate it evaluates to -1 (True)

When I create a new table and use CDate([DOB]) it correctly creates a
date/time field

But the #!***&&& thing will not append to an existing table where the
field is date/time, no formatting. (I did try formats but it did not
help).

Any thoughts. I can see no rhyme nor reason why it should be failing

CatScratch
 
Dear Cat:

I don't see why either. You say it "will not append". Is it that you run
the query and nothing happens? Does it say it appended the rows, but they
aren't appended? Does it give some error message?

The thing about formats is not surprising. Formats change how something is
displayed, not how it is stored. This would have nothing to do with the
problem.

If you have an error, please provide as much diagnostic information as you
have. Just because it does not append does not mean this column is where
the problem is. If you put a constant date value in, like #1/1/2006#, does
it append then? If not, then the problem is elsewhere. If this does fix
it, then probably that is where the problem lies.

Tom Ellison
 
....Validation Rules Violation...
Was the error message.

After reading your post (thanks) I built some basic tables and CDate
worked fine, so I then went back to my working tables and there were
some fields that were required that I was not appending any data into.

sigh....:)

Thanks again

CatScratch
 
Back
Top