Greg
Was using DBF this time and the Copy() function worked great for this one
off but Thanks for the tip, if it was a permanent thing the update query
would be the way. thanks for the addition to my "SQL how to "file.
Patrick Sheehan
----- Original Message -----
From: Greg Nixon <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Sent: 10 September 1999 19:52
Subject: RE: [DUG]: Dates
>
> Depends what database but you should be able to use substring and an
update
> SQL.
>
> eg. Update MyTable set MyDate = SubString(MyDate,1,2) + '/' +
> SubString(MyDate,4,2) + '/' +
> SubString(MyDate,6,2)
>
> If the field isn't big enough you would need to inport it into another
table
> with a bigger field.
>
> The other way would be to also use cast and copy the string to a date
field.
>
> -----Original Message-----
> From: P Sheehan [mailto:[EMAIL PROTECTED]]
> Sent: Friday, 10 September 1999 06:10
> To: Multiple recipients of list delphi
> Subject: [DUG]: Dates
>
>
> How do I get the "/" into the string so I can do a StrtoDate().
> any help appreciated
>
>
> Patrick Sheehan
> P+A Computing
> Patrick Anthony Associates Ltd
> 166 Kitchener Rd Milford
> PO Box 31-831 Milford
> [EMAIL PROTECTED] [EMAIL PROTECTED]
>
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
