<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2726.2500" name=GENERATOR>
<STYLE>@font-face {
font-family: SimSun;
}
@font-face {
font-family: @SimSun;
}
@page Section1 {size: 595.45pt 841.7pt; margin: 1.0in 1.0in 1.0in 1.0in; }
P.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: Arial
}
LI.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: Arial
}
DIV.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: Arial
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
P.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: Arial
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV><SPAN class=590134318-11072003><FONT face=Arial color=#0000ff size=2>IMO
this is a UI-perception problem not a db problem. DateTimes are recorded
serially, therefore there is no issue at the db level about whether date A
precedes date B. Thus this is entirely a UI issue. Depends on what you present
and what the users think your presentation means. For example, I tell my users
to enter the dateTime before their first selection, i.e. 2003-07-31. That way I
can skip the time element.</FONT></SPAN></DIV>
<DIV><SPAN class=590134318-11072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=590134318-11072003><FONT face=Arial color=#0000ff size=2>The
difference between July 1 and July 5 is never 5 days, according to my
calculations.</FONT></SPAN></DIV>
<DIV><SPAN class=590134318-11072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=590134318-11072003><FONT face=Arial color=#0000ff
size=2>Ultimately the point here is that you should be able to compare any two
dates and derive a duration exrpressed in seconds. Then you can format it any
way you want to describe the number of days, hours, minutes and
seconds.</FONT></SPAN></DIV>
<DIV><SPAN class=590134318-11072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=590134318-11072003><FONT face=Arial color=#0000ff
size=2>hth,</FONT></SPAN></DIV>
<DIV><SPAN class=590134318-11072003><FONT face=Arial color=#0000ff
size=2>Arthur</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>Ray
Li<BR><B>Sent:</B> July 11, 2003 1:26 PM<BR><B>To:</B> AccessD@databaseadvisors.
Com<BR><B>Subject:</B> [AccessD] Date difference<BR><BR></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-GB
style="FONT-SIZE: 11pt">If we find the date difference between two dates using
datediff function, it may end up an inaccurate difference. For example,
the start date is </SPAN></FONT><SPAN lang=EN-GB>1 July, 2003</SPAN><SPAN
lang=EN-GB> and the end date is </SPAN><SPAN lang=EN-GB>5 July,
2003</SPAN><SPAN lang=EN-GB>. The difference is 5 days. The answer
may be right or wrong. If the start date is </SPAN><SPAN lang=EN-GB>1
July 2003</SPAN><SPAN lang=EN-GB> </SPAN><SPAN lang=EN-GB>00:00</SPAN><SPAN
lang=EN-GB> and the end date is </SPAN><SPAN lang=EN-GB>6 July
2003</SPAN><SPAN lang=EN-GB> </SPAN><SPAN lang=EN-GB>00:00</SPAN><SPAN
lang=EN-GB>. The accurate answer should be 3-5 days. If we ask the
staff to record the time of start date and end date, human delay and error may
happen too unless there is an aid of time recorder. I would like to know
the general perception of this issue.</SPAN></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-GB
style="FONT-SIZE: 11pt"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-GB
style="FONT-SIZE: 11pt">Thanks,</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-GB
style="FONT-SIZE: 11pt"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-GB
style="FONT-SIZE: 11pt">Ray </SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-GB
style="FONT-SIZE: 11pt"></SPAN></FONT> </P></DIV></BLOCKQUOTE></BODY></HTML>