Date in Access

[T Miller]

How do I change a date in Access that shows 09/01(small 2, in the top)06?

It needs to be 09/01/06

 

[Jerry Whittle]

What does the orginal date look like? What you describe below doesn't make
sense. Are you saying that the date actually looks like:
09/01(small 2, in the top)06

 

[John Vinson]

How do I change a date in Access that shows 09/01(small 2, in the top)06?

It needs to be 09/01/06

What's the datatype of the field? Date/Time or Text? What's the Format
property of the field? Is it showing this in the Table?

If it's a Text field, you may have a "superscript 2" character as a
typo for a slash. You should be able to run an Update query:

UPDATE [yourtablename]
SET [yourdatefieldname] = Replace([yourdatefieldname], Chr(178), "/")
WHERE [yourdatefieldname] LIKE "*" & Chr(178) & "*"


John W. Vinson[MVP]

 

[T Miller]

Jerry,

This was pulled from a text file and the text file had 01/18/06, but when it
was brought into Access it had 01/18²06.

 

[Jerry Whittle]

WOW! That is strange. Short of some corruption issue, it almost has to be
stored in a text field like John suggested. If so, you could use something
like below to update the field or what John suggested:

Left("01/18²06",5) & "/" & right("01/18²06",2)

Then you could use CDate to change it to an actual date. CDate will bomb out
if presented with a Null, empty string, or invalid date like 13/13/06