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

<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 9">
<meta name=Originator content="Microsoft Word 9">
<link rel=File-List href="cid:filelist.xml@01C2FF3A.BB037FF0">
<!--[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>BestFit</w:Zoom>
  <w:DocumentKind>DocumentEmail</w:DocumentKind>
  <w:EnvelopeVis/>
  <w:DrawingGridHorizontalSpacing>5.5 pt</w:DrawingGridHorizontalSpacing>
  <w:DrawingGridVerticalSpacing>14.95 pt</w:DrawingGridVerticalSpacing>
  <w:DisplayHorizontalDrawingGridEvery>0</w:DisplayHorizontalDrawingGridEvery>
  <w:Compatibility>
   <w:FootnoteLayoutLikeWW8/>
   <w:ShapeLayoutLikeWW8/>
   <w:AlignTablesRowByRow/>
   <w:ForgetLastTabAlignment/>
   <w:DoNotUseHTMLParagraphAutoSpacing/>
   <w:LayoutRawTableWidth/>
   <w:LayoutTableRowsApart/>
  </w:Compatibility>
 </w:WordDocument>
</xml><![endif]-->
<style>
<!--
 /* Font Definitions */
@font-face
        {font-family:"CG Omega";
        mso-font-alt:"Century Gothic";
        mso-font-charset:0;
        mso-generic-font-family:swiss;
        mso-font-pitch:variable;
        mso-font-signature:7 0 0 0 147 0;}
 /* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {mso-style-parent:"";
        margin:0cm;
        margin-bottom:.0001pt;
        mso-pagination:widow-orphan;
        font-size:11.0pt;
        mso-bidi-font-size:10.0pt;
        font-family:"CG Omega";
        mso-fareast-font-family:"Times New Roman";
        mso-bidi-font-family:"Times New Roman";
        mso-fareast-language:EN-AU;}
h2
        {mso-style-next:Normal;
        margin-top:0cm;
        margin-right:0cm;
        margin-bottom:18.0pt;
        margin-left:0cm;
        mso-pagination:widow-orphan;
        page-break-after:avoid;
        mso-outline-level:2;
        font-size:14.0pt;
        mso-bidi-font-size:10.0pt;
        font-family:"CG Omega";
        mso-fareast-language:EN-AU;
        mso-bidi-font-weight:normal;}
p.MsoHeader, li.MsoHeader, div.MsoHeader
        {margin:0cm;
        margin-bottom:.0001pt;
        mso-pagination:widow-orphan;
        tab-stops:center 207.65pt right 415.3pt;
        font-size:11.0pt;
        mso-bidi-font-size:10.0pt;
        font-family:"CG Omega";
        mso-fareast-font-family:"Times New Roman";
        mso-bidi-font-family:"Times New Roman";
        mso-fareast-language:EN-AU;}
p.MsoFooter, li.MsoFooter, div.MsoFooter
        {margin:0cm;
        margin-bottom:.0001pt;
        mso-pagination:widow-orphan;
        tab-stops:center 207.65pt right 415.3pt;
        font-size:12.0pt;
        mso-bidi-font-size:10.0pt;
        font-family:"Times New Roman";
        mso-fareast-font-family:"Times New Roman";
        mso-fareast-language:EN-AU;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
        {margin:0cm;
        margin-bottom:.0001pt;
        mso-pagination:widow-orphan;
        font-size:11.0pt;
        mso-bidi-font-size:10.0pt;
        font-family:"CG Omega";
        mso-fareast-font-family:"Times New Roman";
        mso-bidi-font-family:"Times New Roman";
        mso-fareast-language:EN-AU;}
span.EmailStyle19
        {mso-style-type:personal;
        mso-ansi-font-size:10.0pt;
        mso-ascii-font-family:Arial;
        mso-hansi-font-family:Arial;
        mso-bidi-font-family:Arial;
        color:black;}
span.EmailStyle20
        {mso-style-type:personal;
        mso-ansi-font-size:10.0pt;
        mso-ascii-font-family:Arial;
        mso-hansi-font-family:Arial;
        mso-bidi-font-family:Arial;
        color:navy;}
span.EmailStyle21
        {mso-style-type:personal;
        mso-ansi-font-size:10.0pt;
        mso-ascii-font-family:Arial;
        mso-hansi-font-family:Arial;
        mso-bidi-font-family:Arial;
        color:#993366;}
span.EmailStyle22
        {mso-style-type:personal;
        mso-ansi-font-size:10.0pt;
        mso-ascii-font-family:Arial;
        mso-hansi-font-family:Arial;
        mso-bidi-font-family:Arial;
        color:#003300;}
span.EmailStyle23
        {mso-style-type:personal-reply;
        mso-ansi-font-size:10.0pt;
        mso-ascii-font-family:Arial;
        mso-hansi-font-family:Arial;
        mso-bidi-font-family:Arial;
        color:olive;}
@page Section1
        {size:21.0cm 842.0pt;
        margin:70.9pt 3.0cm 70.9pt 3.0cm;
        mso-header-margin:36.0pt;
        mso-footer-margin:31.2pt;
        mso-footer:url("cid:header.htm@01C2FF3A.BB037FF0") f1;
        mso-paper-source:15;}
div.Section1
        {page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext="edit" spidmax="1027"/>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext="edit">
  <o:idmap v:ext="edit" data="1"/>
 </o:shapelayout></xml><![endif]-->
</head>

<body lang=EN-AU style='tab-interval:36.0pt'>

<div class=Section1>

<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=black
face="CG Omega"><span style='font-size:11.0pt;color:black'><![if !supportEmptyParas]> <![endif]></span></font><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>

<p class=MsoNormal style='margin-left:72.0pt'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'>Hi<o:p></o:p></span></font></span></p>

<p class=MsoNormal style='margin-left:72.0pt'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'>I
am exporting from a table to a text file with dates but keep getting the time
in the exported date even though it doesn’t appear in the table.<o:p></o:p></span></font></span></p>

<p class=MsoNormal style='margin-left:72.0pt'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'>I
have tried setting the date to dd-mmm-yyyy in table field but works on 1 table
but not on another table.<o:p></o:p></span></font></span></p>

<p class=MsoNormal style='margin-left:72.0pt'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'>I
have manually set up an export specification (eg ExportLeaseSpecification ) for
each table using ; delimiter and none for text qualifier and : for time
separator.<o:p></o:p></span></font></span></p>

<p class=MsoNormal style='margin-left:72.0pt'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>

<p class=MsoNormal style='margin-left:72.0pt'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'>Code
is:<o:p></o:p></span></font></span></p>

<p class=MsoNormal style='margin-left:72.0pt'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'>‘following
queries export to tmpPASwinExportLease and has 3 date fields with format
dd-mmm-yyyy<o:p></o:p></span></font></span></p>

<p class=MsoNormal style='margin-left:72.0pt'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'><span
style="mso-spacerun: yes">    </span>DoCmd.OpenQuery
"qappExportLeaseHeader"<o:p></o:p></span></font></span></p>

<p class=MsoNormal style='margin-left:72.0pt'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'><span
style="mso-spacerun: yes">    </span>DoCmd.OpenQuery
"qappExportLease"<o:p></o:p></span></font></span></p>

<p class=MsoNormal style='margin-left:72.0pt'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'><span
style="mso-spacerun: yes">    </span>ExportPASwinFile
"ExportLeaseSpecification", "tmpExportLease",
"ExportLease.txt"<o:p></o:p></span></font></span></p>

<p class=MsoNormal style='margin-left:72.0pt'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>

<p class=MsoNormal style='margin-left:72.0pt'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'>The
export works fine but results in <o:p></o:p></span></font></span></p>

<p class=MsoNormal style='margin-left:72.0pt'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>

<p class=MsoNormal style='margin-left:72.0pt'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'>17;21/03/2003;555;;;;;;;;;;;;;;;;;;;;;<o:p></o:p></span></font></span></p>

<p class=MsoNormal style='margin-left:72.0pt'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'>1;N;070;ca;;;;2;12/04/1999;11/4/2004
0:00:00;;;;0;;;;;;;28/3/2003 14:10:56;<o:p></o:p></span></font></span></p>

<p class=MsoNormal style='margin-left:72.0pt'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'>2;N;070;cip;;;;2;1/07/2000;30/6/2004
0:00:00;;;;0;;;;;;;28/3/2003 14:10:56;<o:p></o:p></span></font></span></p>

<p class=MsoNormal style='margin-left:72.0pt'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>

<p class=MsoNormal style='margin-left:72.0pt'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'>and
what I want is <o:p></o:p></span></font></span></p>

<p class=MsoNormal style='margin-left:72.0pt'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>

<p class=MsoNormal style='margin-left:72.0pt'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'>17;21/03/2003;555;;;;;;;;;;;;;;;;;;;;;<o:p></o:p></span></font></span></p>

<p class=MsoNormal style='margin-left:72.0pt'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'>1;N;070;ca;;;;2;12/04/1999;11/4/2004;;;;0;;;;;;;28/3/2003;<o:p></o:p></span></font></span></p>

<p class=MsoNormal style='margin-left:72.0pt'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'>2;N;070;cip;;;;2;1/07/2000;30/6/2004;;;;0;;;;;;;28/3/2003;<o:p></o:p></span></font></span></p>

<p class=MsoNormal style='margin-left:72.0pt'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>

<p class=MsoNormal style='margin-left:72.0pt'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'>Can
anybody help?<o:p></o:p></span></font></span></p>

<p class=MsoNormal style='margin-left:72.0pt'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>

<p class=MsoNormal style='margin-left:72.0pt'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'>Thanks<o:p></o:p></span></font></span></p>

<p class=MsoNormal style='margin-left:72.0pt'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'>Rob<o:p></o:p></span></font></span></p>

<p class=MsoNormal style='margin-left:72.0pt'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>

<p class=MsoNormal style='margin-left:72.0pt'><font size=2 color=black
face="CG Omega"><span style='font-size:11.0pt;color:black'><![if !supportEmptyParas]> <![endif]></span></font><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>

<p class=MsoNormal style='margin-left:72.0pt'><font size=2 color=black
face="CG Omega"><span style='font-size:11.0pt;color:black'><![if !supportEmptyParas]> <![endif]></span></font><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>

<p class=MsoNormal style='margin-left:72.0pt'><font size=2 color=black
face="CG Omega"><span style='font-size:11.0pt;color:black'><![if !supportEmptyParas]> <![endif]></span></font><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>

<p class=MsoNormal style='margin-left:72.0pt'><font size=2 color=black
face="CG Omega"><span style='font-size:11.0pt;color:black'><![if !supportEmptyParas]> <![endif]></span></font><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>

<p class=MsoNormal style='margin-left:72.0pt'><font size=2 color=black
face="CG Omega"><span style='font-size:11.0pt;color:black'><![if !supportEmptyParas]> <![endif]></span></font><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>

<p class=MsoNormal style='margin-left:72.0pt'><font size=2 color=black
face="CG Omega"><span style='font-size:11.0pt;color:black'><![if !supportEmptyParas]> <![endif]></span></font><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>

<p class=MsoNormal style='margin-left:72.0pt'><font size=2 color=black
face="CG Omega"><span style='font-size:11.0pt;color:black'><![if !supportEmptyParas]> <![endif]></span></font><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>

<p class=MsoNormal style='margin-left:72.0pt'><font size=2 color=black
face="CG Omega"><span style='font-size:11.0pt;color:black'><![if !supportEmptyParas]> <![endif]></span></font><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>

<p class=MsoNormal style='margin-left:72.0pt'><font size=2 color=black
face="CG Omega"><span style='font-size:11.0pt;color:black'><![if !supportEmptyParas]> <![endif]></span></font><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>

<p class=MsoNormal style='margin-left:72.0pt'><font size=2 color=black
face="CG Omega"><span style='font-size:11.0pt;color:black'><![if !supportEmptyParas]> <![endif]></span></font><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>

<p class=MsoNormal style='margin-left:72.0pt'><font size=2 color=black
face="CG Omega"><span style='font-size:11.0pt;color:black'><![if !supportEmptyParas]> <![endif]></span></font><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>

<p class=MsoNormal style='margin-left:72.0pt'><font size=2 color=black
face="CG Omega"><span style='font-size:11.0pt;color:black'><![if !supportEmptyParas]> <![endif]></span></font><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>

<p class=MsoNormal align=center style='margin-left:72.0pt;text-align:center'><font
size=2 color=black face="CG Omega"><span style='font-size:10.0pt;color:black'><![if !supportEmptyParas]> <![endif]></span></font><font
size=2 color=black><span style='font-size:10.0pt;color:black;mso-color-alt:
windowtext'><o:p></o:p></span></font></p>

</div>

</body>

</html>