Date in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 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
 
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
Click to expand...

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]
 
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.
 
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
 
Back
Top