Conversion of Number to Date Format

[sms28]

I have a table with a field, DOB, defined as a number. This field is date of birth. For example, the data appears as 19860302 - I need this to be 03/02/1986 in date format. Any ideas how I can accomplish?

Thanks in advance.

 

[hneal98]

is this a one time thing, and is the field a numeric field or text?

 

[grnzbra]

newdob = mid(dob,5,2) & "/" & Right(dob,2) & "/" & Left(dob,4)

 

[sms28]

Thanks. The suggestion from grnzbra worked.

 

[hneal98]

Wonderful how everyone just jumps in whithout knowing the details. Glad it helped.

 

[btringham]

This works so far - ie makes it look like a date, but trying to use datediff using this newdob field doesn't.
Any thoughts?

 

[hneal98]

cdate(newdob)

The cdate converts the string to a date. So if you use datediff, you would do it like this:

datediff(yyyy, cdate(newdob),now())

Not sure how you want to use it. This is just an example.