<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.00.3314.2100" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=270435514-08022003>I am
using Right([DateRequested],4). Since some of the records were imported from a
Word file (what was used as the log previously), the DateRequested dates do
not have the date & time, they show the time as 12:00:00 AM. I have
DateRequested as a Date/Time showing the time requested along with the date. I
am getting the year on most of the them, but the new records show 9 AM or 3 PM
(which would be the last 4).</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=270435514-08022003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=270435514-08022003>Virginia</SPAN></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Hollis,Virginia
[mailto:HollisVJ@pgdp.usec.com]<BR><B>Sent:</B> Saturday, February 08, 2003
8:49 AM<BR><B>To:</B> 'accessd@databaseadvisors.com'<BR><B>Subject:</B>
[AccessD] Putting Dates in Order<BR><BR></DIV></FONT>
<DIV><FONT face=Arial size=2><SPAN class=530254514-08022003>Is there anyway to
get dates in order? </SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=530254514-08022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=530254514-08022003>I try Ascending
& get:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=530254514-08022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=530254514-08022003>01/01/2001</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=530254514-08022003>01/01/2003</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=530254514-08022003>02/01/2001</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=530254514-08022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=530254514-08022003>I
want:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=530254514-08022003>01/01/2001</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=530254514-08022003>02/01/2001</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=530254514-08022003>01/01/2003</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=530254514-08022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=530254514-08022003></SPAN></FONT> </DIV></BLOCKQUOTE></BODY></HTML>