Converting table values

[Delameko]

I've been given a database to work with containing 3500 records.

After trying (and failing) to get it to work properly with my ASP code I discovered that the three date fields (day 00, month 00, year 0000) were all text fields.

Is there any easy way convert these to number/dates? (Maybe day/month/year into the date format 00/00/0000 in one field?)


(I am a newbie, and am still learning my way way round databases, so go easy ;-P)

 

[mhartman1]

Hello:

What you want to do is concatenate all the fields together and then use the CDate function. This should do it.

Regards
Mark

 

[JerryKlmns]

Or in one step returning true date data

DateSerial(TheYearField, TheMonthField, TheDayField)