beginning/end of month

Wed, 10 Nov 2004 11:25:36 -0600

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C4C74A.4D58FAF4
Content-Type: text/plain;
	charset="iso-8859-1"

Hi List!

I was wondering if someone can tell me the most efficient way to derived the
beginning and end of month. We are running an extract on the first of every
month and the date parameters need to be from the 1st through the last day
of the previous month. I know there is a MONTH function as well as LASTDAY,
DATEEXTRACT, etc. but deriving and converting the dates seems very
cumbersome. Any suggestions are greatly appreciated.

OpenVMS V7.3-2
Quiz V7.10.G4

Thank you,
Kristina Carlton
Senior Programmer/Analyst
The JI Companies
512.427.2459
kristina.carlton@jicompanies.com

------_=_NextPart_001_01C4C74A.4D58FAF4
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">

<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 9">
<meta name=3DOriginator content=3D"Microsoft Word 9">
<link rel=3DFile-List href=3D"cid:filelist.xml@01C4C717.FFA364D0">
<!--[if gte mso 9]><xml>
 <o:OfficeDocumentSettings>
  <o:DoNotRelyOnCSS/>
 </o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <w:WordDocument>
  <w:View>Normal</w:View>
  <w:Zoom>0</w:Zoom>
  <w:DocumentKind>DocumentEmail</w:DocumentKind>
  <w:EnvelopeVis/>
  <w:DrawingGridHorizontalSpacing>2.85 =
pt</w:DrawingGridHorizontalSpacing>
  =
<w:DisplayVerticalDrawingGridEvery>2</w:DisplayVerticalDrawingGridEvery>=

 </w:WordDocument>
</xml><![endif]-->
<style>
<!--
 /* Font Definitions */
@font-face
	{font-family:"Century Gothic";
	panose-1:2 11 5 2 2 2 2 2 2 4;
	mso-font-charset:0;
	mso-generic-font-family:swiss;
	mso-font-pitch:variable;
	mso-font-signature:647 0 0 0 159 0;}
 /* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{mso-style-parent:"";
	margin:0in;
	margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:9.0pt;
	mso-bidi-font-size:12.0pt;
	font-family:"Century Gothic";
	mso-fareast-font-family:"Times New Roman";
	mso-bidi-font-family:"Courier New";}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
	{margin:0in;
	margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:9.0pt;
	mso-bidi-font-size:12.0pt;
	font-family:"Century Gothic";
	mso-fareast-font-family:"Times New Roman";
	mso-bidi-font-family:"Courier New";}
span.EmailStyle15
	{mso-style-type:personal-compose;
	mso-ansi-font-size:9.0pt;
	mso-ascii-font-family:"Century Gothic";
	mso-hansi-font-family:"Century Gothic";
	mso-bidi-font-family:Arial;
	color:#333399;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;
	mso-header-margin:.5in;
	mso-footer-margin:.5in;
	mso-paper-source:0;}
div.Section1
	{page:Section1;}
-->
</style>
</head>

<body lang=3DEN-US style=3D'tab-interval:.5in'>

<div class=3DSection1>

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D1 =
color=3D"#333399"
face=3D"Century Gothic"><span style=3D'font-size:9.0pt'><span =
style=3D'mso-bidi-font-size:
12.0pt'>Hi List!<o:p></o:p></span></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D1 =
color=3D"#333399"
face=3D"Century Gothic"><span style=3D'font-size:9.0pt'><![if =
!supportEmptyParas]>&nbsp;<![endif]></span><o:p></o:p></font></span></p>=

I was wondering if someone can tell me the most =
efficient way to
derived the beginning and end of month. We are running an extract on =
the first
of every month and the date parameters need to be from the =
1st through
the last day of the previous month. I know there is a MONTH =
function as
well as LASTDAY, DATEEXTRACT, etc. but deriving and converting the =
dates seems
very cumbersome. Any suggestions are greatly =
appreciated.<o:p></o:p>

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D1 =
color=3D"#333399"
face=3D"Century Gothic"><span style=3D'font-size:9.0pt'><![if =
!supportEmptyParas]>&nbsp;<![endif]></span><o:p></o:p></font></span></p>=

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D1 =
color=3D"#333399"
face=3D"Century Gothic"><span style=3D'font-size:9.0pt'><span =
style=3D'mso-bidi-font-size:
12.0pt'>OpenVMS V7.3-2<o:p></o:p></span></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D1 =
color=3D"#333399"
face=3D"Century Gothic"><span style=3D'font-size:9.0pt'><span =
style=3D'mso-bidi-font-size:
12.0pt'>Quiz V7.10.G4<o:p></o:p></span></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D1 =
color=3D"#333399"
face=3D"Century Gothic"><span style=3D'font-size:9.0pt'><![if =
!supportEmptyParas]>&nbsp;<![endif]></span><o:p></o:p></font></span></p>=

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D1 =
color=3D"#333399"
face=3D"Century Gothic"><span style=3D'font-size:9.0pt'><span =
style=3D'mso-bidi-font-size:
12.0pt'>Thank you,<o:p></o:p></span></span></font></span></p>

<p class=3DMsoAutoSig><!--[if supportFields]><font =
color=3D"#333399"><span=20
style=3D'color:#333399'><span =
style=3D'mso-element:field-begin'></span><span=20
style=3D"mso-spacerun: yes">&nbsp;</span>AUTOTEXTLIST \s &quot;E-mail=20
Signature&quot; <span =
style=3D'mso-element:field-separator'></span></span></font><![endif]--><=
font
color=3D"#333399"><span style=3D'color:#333399'>Kristina =
Carlton</span></font><font
color=3D"#333399"><span =
style=3D'color:#333399;mso-color-alt:windowtext'><o:p></o:p></span></fon=
t></p>

<p class=3DMsoAutoSig><font size=3D1 color=3D"#333399" face=3D"Century =
Gothic"><span
style=3D'font-size:9.0pt;color:#333399'><span =
style=3D'mso-bidi-font-size:12.0pt'>Senior
Programmer/Analyst</span></span></font><font color=3D"#333399"><span
style=3D'color:#333399;mso-color-alt:windowtext'><o:p></o:p></span></fon=
t></p>

<p class=3DMsoAutoSig><font size=3D1 color=3D"#333399" face=3D"Century =
Gothic"><span
style=3D'font-size:9.0pt;color:#333399'><span =
style=3D'mso-bidi-font-size:12.0pt'>The
JI Companies</span></span></font><font color=3D"#333399"><span =
style=3D'color:#333399;
mso-color-alt:windowtext'><o:p></o:p></span></font></p>

<p class=3DMsoAutoSig><font size=3D1 color=3D"#333399" face=3D"Century =
Gothic"><span
style=3D'font-size:9.0pt;color:#333399'><span =
style=3D'mso-bidi-font-size:12.0pt'>512.427.2459</span></span></font><fo=
nt
color=3D"#333399"><span =
style=3D'color:#333399;mso-color-alt:windowtext'><o:p></o:p></span></fon=
t></p>

<p class=3DMsoAutoSig><font size=3D1 color=3D"#333399" face=3D"Century =
Gothic"><span
style=3D'font-size:9.0pt;color:#333399'><span =
style=3D'mso-bidi-font-size:12.0pt'>kristina.carlton@jicompanies.com</sp=
an></span></font><font
color=3D"#333399"><span =
style=3D'color:#333399;mso-color-alt:windowtext'><o:p></o:p></span></fon=
t></p>

<p class=3DMsoNormal><!--[if supportFields]><font =
color=3D"#333399"><span=20
style=3D'color:#333399'><span =
style=3D'mso-element:field-end'></span></span></font><![endif]--><font
color=3D"#333399"><span style=3D'color:#333399'><![if =
!supportEmptyParas]>&nbsp;<![endif]></span></font><font
color=3D"#333399"><span =
style=3D'color:#333399;mso-color-alt:windowtext'><o:p></o:p></span></fon=
t></p>

</div>

</body>

</html>

------_=_NextPart_001_01C4C74A.4D58FAF4--