Skip to Content
author's profile photo Former Member
Former Member

gr date is invalid in report

Hi

I have an issue in one of my report gr date is showing invalid date like item actually dated in 1st july 2011 but in query output its showing as 07/01/2011.

and also some time its showing 00/00/000.

can please some one help me how to solve this issue.

Thanks

Bhaskar

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jun 11, 2012 at 12:34 PM

    Is it a standard report or Z report.

    In first case it shows in MM/DD/YYYY format.. So this can be set by User Profle.. SU01.

    Secondly for showing 00/00/0000 - Iwould like to know more detail.. if it is a Z program then whould like to see th code

    Regards,

    Venkat

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 11, 2012 at 12:52 PM

    Hi Bhaskar,

    It looks like, the date is showing in the format MM/DD/YYYY.

    In your case, 1-July-2011 as 7/1/2012(MM/DD/YYYY).

    In order to get it in DD/MM/YYYY format kindly do the following system setting chane.

    Goto Control Panel > Regional & Language Options >

    tab Date > choose or type your Short Date Format as (DD.MM.YYYY)

    For your 2nd issue: Date is showing like 00/00/0000.

    I think, the date filed value would be balnk for that record. That would be the reason to get value as 0.

    In order to resolve this issue, you can create transformation routine for that field to be blank if no value exist.

    Cheers 😊

    Regards,

    Karthick.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi karthic

      Good one.

      just i checked the data in infoprovider its a key figure and showing value as 734,320 but in query output its showing 07.01.2011.

      in infoprovider level the keyfigure defined data type as date (Dec-counter or amount field with comma and sign.)

      In query level there is no CKF and variables

      and in rsa1- kf definition -------

      aggeregation tab

      AGGREGATION-----> maximun.

      EXCEPTION AGGREGATION----->no aggregation (X,If more than one value occur)

      Agregation ref char-------------------------->Zgspinvnl (Gsap invoicenumber) its a charactrstick

      ADDITIONAL PROPERTY TAB

      BEX DESCRIPTION-----------------------------> short desc

      only above values in kf definition and no ckf and varibles in designer, in infoprovider output data showing number and query output showing date can some one help me how it converted from number to date

      please explain how the number 734,320 converted in to date 07.01.2011.

      Thanks

      BHaskar

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.