Access stores a DateTime field as a number.  You should store this one field
and use your 'presentation layer' to display the correct part of it in two
different text boxes for example.  I think ASP/VBScript has a DatePart
function which should help with this.

HTH,
Col

-----Original Message-----
From: Drew, Ron [mailto:RDrew@B...]
Sent: 31 July 2002 13:22
To: ASP Databases
Subject: [asp_databases] Time needed


I have a field on an access database defined as datetime, how can I
display the date in one field and the time in another.  Is there a
function to do this???




*******

This message and any attachment are confidential and may be privileged or otherwise protected from disclosure.  If you are not the
intended recipient, please telephone or email the sender and delete this message and any attachment from your system.  If you are
not the intended recipient you must not copy this message or attachment or disclose the contents to any other person.

For further information about Clifford Chance please see our website at http://www.cliffordchance.com or refer to any Clifford
Chance office.

I have a field on an access database defined as datetime, how can I
display the date in one field and the time in another.  Is there a
function to do this???