create a single date column from seperate month, day and year colu

[UGAJohn]

The data I received came with the month day and year seperated out into
seperate columns. I manage to concantenate the date to show i.e. 112002 or
10102002 representing 1/1/2002 and 10/10/2002. What can I do to create a
date field from this or should I use the seperate columns to create a date
field.

Thanks

 

[golfinray]

Try Format([SomeFieldName],"Short Date")

 

[KARL DEWEY]

should I use the seperate columns to create a date field.
Yes -- Your 112002 will be a problem as well as 1112002. Is the latter 1
NOV 2002 or 11 JAN 2002.

If all dates are 8 digits then the below will work --
CVDate(Right([ENTER DATE],4) & "/" & Left([ENTER DATE],2) & "/" & Mid([ENTER
DATE],3,2))

 

[John W. Vinson]

The data I received came with the month day and year seperated out into
seperate columns. I manage to concantenate the date to show i.e. 112002 or
10102002 representing 1/1/2002 and 10/10/2002. What can I do to create a
date field from this or should I use the seperate columns to create a date
field.

Thanks

If you have three number fields for month, day and year, use

DateSerial([yearfield], [monthfield], [dayfield])

to calculate an Access Date/Time field.

Concatenation will produce an ambiguous number, not a date.