<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@01C2FB65.7D0D5690">
<!--[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-reply;
mso-ansi-font-size:10.0pt;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:#003300;}
@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@01C2FB65.7D0D5690") 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'><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:36.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:36.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:36.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:36.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:36.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:36.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:36.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:36.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:36.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:36.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:36.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:36.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:36.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:36.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:36.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:36.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:36.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:36.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:36.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:36.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:36.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:36.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:36.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:36.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:36.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:36.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:36.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: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: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: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: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: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: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: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: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: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: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: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: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 align=center style='margin-left:36.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>