How to adjust date format in business graphics in wda

[Former Member]

Hello Experts,

In business graphics(GRAPHS ), how can we achieve the proper date ...

In my case, The date is coming as 20120702, 20120712, 20120722, 20120732, 20120742,20120752,20120762,20120772,20120782,20120792,20120802.

I want it to be in proper date format..

Please help.

Thanks and regards,

Gaur Mayank

[former_member222068]

Hi Mayank,

  Use the system variable SY-DATUM. It gives you the format DD.MM.YYYY.

Sample Code:

data : lv_date type sy-datum.

lv_date = sy-datum.

WRITE lv_date.

[Former Member]

Dear Sankar,

the values afterwards are not coming correct..

It is increasing numerically,.

It should increase as months..

Check the bold dates..

And le me know the solution.

Regards,

Gaur Mayank

[former_member222068]

Hi Maynak,

  Are you looking for date format or else?

Can you add what is your requirement. If possible can you keep a screen shot.

[Former Member]

Date format in graph..

it is coming like 20120705.

I am ok with this format.

The problem is the date range, is coming numerically .

i.e.

after 20120730 20120740 20120750 and so on is coming.

20120740( it is increasing numerically  though after 20120730 , 20120810 should come ideally ..)

means. 40.07.2012 which is invalid date.

So how to correct this error...??

Regards,
Gaur Mayank

[former_member222068]

Hi Mayank,

Sample Code:

data : lv_date type sy-datum.

lv_date = sy-datum.
do 10 TIMES.
lv_DATE+4(2) = lv_DATE+4(2) + 1.

WRITE lv_date.

ENDDO.

Output:

05.08.2012 05.09.2012 05.10.2012 05.11.2012 05.12.2012 05.13.2012 05.14.2012 05.15.2012 05.16.2012 05.17.2012

Is this what you are looking for. If not let me know by correcting the Output format of what you are looking

Have a look at this FM :

BKK_ADD_MONTH_TO_DATE. May be useful

Thanks & Regards,

Sankar Gelivi

[Former Member]

I am asking in graph..

Because  in graph this thing is not working.

I have  tried this.

The date range which it is showing on Y-axis is not coming properly.

I am ok with the format but it is showing invalid date also..

[Former Member]

Dear Mayank,

Try with the Conversion FM's...

Eg:

DATA lv_date TYPE sy-datum.

data lv_datum(10).

lv_date = sy-datum.

*WRITE 😕 lv_date.

CALL FUNCTION 'CONVERSION_EXIT_IDATE_OUTPUT'

   EXPORTING

     input  = lv_date

   IMPORTING

     output = lv_datum.