HI...thanks for the reply.......This is how I am currently doing it,
although, I have to confess, I am doing this mainly in VB 6, and not
delphi, and that it why I made it off topic, even though I did get the same
result in Delphi....hehehehehe
One idea that was suggested was, passing the date as a string parameter to
the stored proc, and THEN converting it to a date in there.....so I will
give that a go.....
Cheers, Jeremy Coulter
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED]
> Sent: Monday, February 22, 1999 17:51
> To: Multiple recipients of list offtopic
> Subject: Re: [DUG-OFFTOPIC]: Passing Dates In Crystal Reports
>
>
>
>
>
> We use the Crystal VCL component to interact with Sybase Stored Procedures
> in a Crystal report.
>
> We use the FormatDateTime function using the format 'yyyy-mm-dd
> hh:mm:ss.000' and set the SQL.Params[x].Value
>
> TCrpe.SQL.Params[x].Value := FormatDateTime('yyyy-mm-dd
> hh:mm:ss.000',Date);
>
>
> ------------------------------------------------------------------
> ---------
> New Zealand Delphi Users group - Offtopic List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Offtopic List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
