Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2004
    Posts
    6

    Unanswered: Date format when using Oracle stored procs

    Hi,

    I am generating a report in Crystal using Oracle Stored procedures. The input parameter to the stored procedure is a date. Can I control the format of the input date paramter in Crystal. Currently Crystal shows the input date field in DateTime (MM/DD/YYYY hh:mi:ss)format. Is it possible to change it to Date (MM/DD/YYYY) format.

    Thanks in advance,
    Aby

  2. #2
    Join Date
    Oct 2003
    Posts
    357

    Thumbs up

    Hi, Right click on the datefield and select format field. In the menu choose the dateformat you want

    Madhivanan

  3. #3
    Join Date
    Dec 2004
    Posts
    6
    Hi Madhivanan,

    The date field is not on the report. It is the field for accepting the input date parameter. When using stored procedures, the value type parameter defaults to 'DateTime' and is disabled. Is there any way to change that.

    Thanks,
    Aby

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •