I haven't used Crystal Reports, but a common date format in queries is YYYY-MM-DD, rather than MM/DD/YYYY.
Jason.
On 03/08/2004, at 3:01 AM, Barbara McCormick wrote:
Hello,
I need to send a datetime variable from Witango to a crystal report based on a stored procedure.
Can you help me out?
I’ve tried many variations of
@startdate=<@DQ><@arg NAME='startdate' Format='datetime:%m/%d/%Y %H:%M:%S'><@DQ>
Can you please help me with the formatting of this?
Barb
Barbara McCormick
MIS Department/Extranet
Capital Pacific Homes, Inc.
480-777-2400
[EMAIL PROTECTED]
<x-tad-bigger> </x-tad-bigger>
________________________________________________________________________<x-tad-bigger>
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
</x-tad-bigger><x-tad-bigger>WITH IMAGINATION
</x-tad-bigger><x-tad-bigger>Planning, Implementation and Management of Web Applications
</x-tad-bigger><x-tad-bigger>
</x-tad-bigger><x-tad-bigger>160 Pacific Highway North Sydney NSW Australia 2060</x-tad-bigger><x-tad-bigger>
</x-tad-bigger><x-tad-bigger>phone +</x-tad-bigger><x-tad-bigger> </x-tad-bigger><x-tad-bigger>612 9929 9229</x-tad-bigger><x-tad-bigger> </x-tad-bigger><x-tad-bigger>fax +</x-tad-bigger><x-tad-bigger> </x-tad-bigger><x-tad-bigger>612 9460 4770</x-tad-bigger><x-tad-bigger>
</x-tad-bigger><x-tad-bigger>web -</x-tad-bigger><x-tad-bigger> </x-tad-bigger><x-tad-bigger> </x-tad-bigger><x-tad-bigger>email -</x-tad-bigger><x-tad-bigger> </x-tad-bigger><x-tad-bigger>[EMAIL PROTECTED]
</x-tad-bigger>