Date calculations
Viet Nguyen
VNguyen@wsboces.org
Wed, 2 Feb 2005 11:19:35 -0500
This is a multi-part message in MIME format.
------_=_NextPart_001_01C50942.FC8236D4
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
Hello ,
I got this answer and it worked:
=20
DEFINE RUNDT DATE =3D DATE( DAYS(SYSDATE) - 1 )
=20
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Kristina Carlton
Sent: Wednesday, February 02, 2005 11:12 AM
To: 'powerh-l@lists.sowder.com'
Subject: Date calculations
=20
Yesterday some emails were exchanged on calculating dates and that "DATE
- 1" came up with an incorrect date of 02.00.2005. I calculate my date
with the following syntax:
=20
DEFINE RUNDT DATE =3D DATE(DAYS(SYSDATE - 1))
=20
This has worked every night except yesterday - February 1st. When I
display RUNDT it actually has Januray 31st, 2005 but when I run the
extract I get zero records. If I hard code January 31st, 2005 I do get
records back. Am I doing something wrong? I got my data, but I would
like to understand why this is happening.
=20
We have OpenVMS V7.3-2 and I am using a Quiz extract.
=20
Thanks,
Kristina Carlton
Senior Programmer/Analyst
The JI Companies
Kristina.Carlton@JICompanies.com
=20
------_=_NextPart_001_01C50942.FC8236D4
Content-Type: text/html;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
<html>
<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Century Gothic";
panose-1:2 11 5 2 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:9.0pt;
font-family:"Century Gothic";
color:black;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;
margin-bottom:.0001pt;
font-size:9.0pt;
font-family:"Century Gothic";
color:black;}
span.EmailStyle16
{font-family:"Century Gothic";
color:navy;
font-weight:normal;
font-style:normal;}
span.EmailStyle19
{font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Hello ,</span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>I got this answer and it =
worked:</span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle16><font
size=3D1 color=3Dnavy face=3D"Century Gothic"><span =
style=3D'font-size:7.5pt'> </span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle16><font
size=3D1 color=3Dnavy face=3D"Century Gothic"><span =
style=3D'font-size:9.0pt'>DEFINE
RUNDT DATE =3D =
DATE( DAYS(SYSDATE) – 1 =
)</span></fon=
t></span></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dblack
face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma;color:windowtext'>-----Origi=
nal
Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b>
powerh-l-admin@lists.sowder.com [mailto:powerh-l-admin@lists.sowder.com] =
<b><span
style=3D'font-weight:bold'>On Behalf Of </span></b>Kristina Carlton<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> </span></font><font =
size=3D2 color=3Dblack face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma;
color:windowtext'>Wednesday, February 02, 2005</span></font><font =
size=3D2
color=3Dblack face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma;
color:windowtext'> </span></font><font size=3D2 color=3Dblack =
face=3DTahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma;color:windowtext'>11:12 =
AM</span></font><font
size=3D2 color=3Dblack face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma;
color:windowtext'><br>
<b><span style=3D'font-weight:bold'>To:</span></b> =
'powerh-l@lists.sowder.com'<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> Date =
calculations</span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D1 =
color=3Dblack
face=3D"Century Gothic"> </font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle16><font
size=3D1 color=3Dnavy face=3D"Century Gothic"><span =
style=3D'font-size:9.0pt'>Yesterday
some emails were exchanged on calculating dates and that “DATE =
–
1” came up with an incorrect date of 02.00.2005. I calculate my =
date with
the following syntax:</span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle16><font
size=3D1 color=3Dnavy face=3D"Century Gothic"><span =
style=3D'font-size:7.5pt'> </span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle16><font
size=3D1 color=3Dnavy face=3D"Century Gothic"><span =
style=3D'font-size:9.0pt'>DEFINE
RUNDT DATE =3D DATE(DAYS(SYSDATE - =
1))</span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle16><font
size=3D1 color=3Dnavy face=3D"Century Gothic"><span =
style=3D'font-size:7.5pt'> </span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle16><font
size=3D1 color=3Dnavy face=3D"Century Gothic"><span =
style=3D'font-size:9.0pt'>This has
worked every night except yesterday – February 1<sup>st</sup>. =
When I
display RUNDT it actually has Januray 31<sup>st</sup>, 2005 but when I =
run the
extract I get zero records. If I hard code January 31<sup>st</sup>, 2005 =
I do
get records back. Am I doing something wrong? I got my data, but I would =
like
to understand why this is happening.</span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle16><font
size=3D1 color=3Dnavy face=3D"Century Gothic"><span =
style=3D'font-size:7.5pt'> </span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle16><font
size=3D1 color=3Dnavy face=3D"Century Gothic"><span =
style=3D'font-size:9.0pt'>We have
OpenVMS V7.3-2 and I am using a Quiz extract.</span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle16><font
size=3D1 color=3Dnavy face=3D"Century Gothic"><span =
style=3D'font-size:7.5pt'> </span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle16><font
size=3D1 color=3Dnavy face=3D"Century Gothic"><span =
style=3D'font-size:9.0pt'>Thanks,</span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span
class=3DEmailStyle16><font color=3Dnavy face=3D"Century Gothic">Kristina =
Carlton</font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle16><font
size=3D1 color=3Dnavy face=3D"Century Gothic"><span =
style=3D'font-size:9.0pt'>Senior
Programmer/Analyst</span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle16><font
size=3D1 color=3Dnavy face=3D"Century Gothic"><span =
style=3D'font-size:9.0pt'>The JI
Companies</span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle16><font
size=3D1 color=3Dnavy face=3D"Century Gothic"><span =
style=3D'font-size:9.0pt'>Kristina.Carlton@JICompanies.com</span></font><=
/span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'> </p>
</div>
</body>
</html>
=00
------_=_NextPart_001_01C50942.FC8236D4--