<br><font size=2 face="sans-serif">Please disregard last post...i have solved the issue by casting the date as dd/mmm/yyyy as opsosed to dd/mm/yyyy or mm/dd/yyyy</font>
<br>
<br><font size=2 face="sans-serif">Robert Wilson</font><font size=3 face="Times New Roman"> </font>
<p><font size=2 color=#000080 face="Tahoma">IS Developer<b> </b></font>
<p><font size=2 color=#000080 face="Tahoma"><b>Cellect and IT Wholesale</b></font><font size=3 face="Times New Roman"> </font>
<p><font size=2 color=#000080 face="Tahoma">Ph: +64 (0) 9 415 4747</font><font size=3 face="Times New Roman"> </font>
<p>
<br>
<br>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td>
<td><font size=1 face="sans-serif"><b>"Robert Wilson" <robertw@cellect.co.nz></b></font>
<br><font size=1 face="sans-serif">Sent by: delphi-bounces@ns3.123.co.nz</font>
<p><font size=1 face="sans-serif">02/09/2004 09:55 a.m.</font>
<br><font size=1 face="sans-serif">Please respond to NZ Borland Developers Group - Delphi List</font>
<br>
<td><font size=1 face="Arial"> </font>
<br><font size=1 face="sans-serif"> To: "NZ Borland Developers Group - Delphi List" <delphi@ns3.123.co.nz></font>
<br><font size=1 face="sans-serif"> cc: </font>
<br><font size=1 face="sans-serif"> Subject: [DUG] Interbase dates</font></table>
<br>
<br>
<br><font size=2 face="sans-serif"><br>
Hi</font><font size=3 face="Times New Roman"> <br>
</font><font size=2 face="sans-serif"><br>
Wondering if anyone can shed some light on a problem i'm having with interbase dates. I have an app that pumps data from foxpro table to a new interbase db, when doing comparsion after transfering data there is a problem with some of the dates.</font><font size=3 face="Times New Roman"> </font><font size=2 face="sans-serif"><br>
Dates that were dates within foxpro datatables are fine</font><font size=3 face="Times New Roman"> </font><font size=2 face="sans-serif"><br>
Dates that were stored as characters in foxpro if eg 12/07/2004 end up as 07/12/2004 but 22/07/2004 transfer correctly using the same procedure, it doesn't seem to make any difference what formatting is done before inserting them into interbase, they still come out the same.</font><font size=3 face="Times New Roman"> <br>
</font><font size=2 face="sans-serif"><br>
Cheers</font><font size=3 face="Times New Roman"> </font><font size=2 face="sans-serif"><br>
Robert Wilson</font><font size=3 face="Times New Roman"> </font>
<p><font size=2 color=#000080 face="Tahoma">IS Developer<b> </b></font>
<p><font size=2 color=#000080 face="Tahoma"><b>Cellect and IT Wholesale</b></font><font size=3 face="Times New Roman"> </font>
<p><font size=2 color=#000080 face="Tahoma">Ph: +64 (0) 9 415 4747</font><font size=3 face="Times New Roman"> </font>
<hr><font size=3 color=red face="Times New Roman"><b>Attention: </b></font><font size=3 face="Times New Roman"><br>
Disclaimer: </font>
<p><font size=3 face="Times New Roman">The information in this electronic mail message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this Internet electronic mail message by anyone else is unauthorised. </font>
<p><font size=3 face="Times New Roman">If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. <br>
If you have received this e-mail by mistake please call the sender immediately on 09 415 4747 and erase the original message and any attachments.</font>
<p><font size=3 face="Times New Roman">Cellular Cellnet (NZ) Ltd accepts no responsibility for any effects this email message or attachments has on the recipient network or computer system. </font>
<hr><font size=2 face="Courier New">_______________________________________________<br>
Delphi mailing list<br>
Delphi@ns3.123.co.nz<br>
http://ns3.123.co.nz/mailman/listinfo/delphi<br>
</font>
<p>
<p>
<HR><STRONG><FONT COLOR=#ff0000>
Attention: </FONT></STRONG><BR>
Disclaimer:
<P>The information in this electronic mail message is confidential and may be
legally privileged. It is intended solely for the addressee. Access to this
Internet electronic mail message by anyone else is unauthorised. </P>
<P>If you are not the intended recipient, any disclosure, copying, distribution
or any action taken or omitted to be taken in reliance on it is prohibited and
may be unlawful. <BR>If you have received this e-mail by mistake please
call the sender immediately on 09 415 4747 and erase the original message and
any attachments.</P>
<P>Cellular Cellnet (NZ) Ltd accepts no responsibility for any
effects this email message or attachments has on the recipient network
or computer system.
<HR>
<P></P>