Changing Dates in Access

[doorok]

I'm querying my corporate database in access and I have run into problems with the way my db outputs dates. When I have a date field the dates are display as yyyymmdd or February 22, 2003 would be 20030122. This makes it impossible for me to perform calculations on the dates. Does anyone know how I can get access to convert this format to mmddyyyy?

Thanks

 

[danvlas]

February 22, 2003 would be 20030222.

Funny...Have you checked the Format property in the tables, forms and reports? You may find something like:
"yyyymmdd"

Just delete the format and you're (almost) set.

Good luck

Daniel Vlas
Systems Consultant

 

[JimInKS]

Are you sure your corporate db is not just returning dates as text?

You could write a little function to convert the text version to a real date in access. Something like:

function StrToDate(strDate as string) as date
StrToDate = Mid(strDate, 5, 2) & "/" & Right(strDate, 2) & "/" & Left(strDate, 4)
end function

Any Access Guru's out there with a more elegant solution?