[AccessD] Date Issue

Terri Jarus jarus at amerinet-gpo.com
Wed Jan 5 06:28:27 CST 2005


I am linked to a table of data from our AS400/DB2 system and a date
field appears as 20050105.  I need Access to read this as a date - what
is the best way to handle/convert this field.  I've tried breaking it
apart and putting it back together in a query as 01-05-2005 but Access
does not recognize as a date field.  I want to query out data based on a
date - please advise.
 
Thanks for your help.
 
Terri Jarus
Vice President, Contract Services
jarus at amerinet-gpo.com
314-542-1902

---------------------------------------------------------------------------
This email and any files transmitted with it are confidential and
intended solely for the use of the individuals or entities to whom they
are addressed. If you have received this email in error please return 
it to the sender, and erase any copies thereof.
Copyright 2004 Amerinet 1nc.


More information about the AccessD mailing list