topic Re: Date format in Application Development and Automation Discussions

Date format

Former Member — Thu, 02 Mar 2006 08:58:52 GMT

Hi!

How can convert variable(date) from format yyy.mm.dd to dd.mm.yyyy?

Thanks forehead!

Re: Date format

FredericGirod — Thu, 02 Mar 2006 09:02:39 GMT

Hi,

if you want to display into your screen, just write the variable type d.

write w_date (that will show you as your country standard)

if you want to set into a char type

concatenate date6(2) date4(2) date+0(4) into w_char separated by '.'.

Remember that SAP store date into a type and display sometime into another one. SAP used field-exit to perform this.

Rgd

Frédéric

Re: Date format

vinod_gunaware2 — Thu, 02 Mar 2006 09:02:43 GMT

Use write statement.

use f1 or goto pattarn -> WRITE -> FIELD(specify name)->

Multiple selection(yellow arrow button button)-> for date fields (Chck box and radio button)

WRITE - Formatting options

... DD/MM/YY

... MM/DD/YY

... DD/MM/YYYY

... MM/DD/YYYY

... DDMMYY

... MMDDYY

... YYMMDD

U can use into another variable.

and then use that particular variable.

regards

vinod

Message was edited by: Vinod Gunaware

Re: Date format

Former Member — Thu, 02 Mar 2006 09:03:15 GMT

Hi Welcome !!

System menu~~>user profile~~>own data ~~>defaults~~>date format set to dd.mm.yyyy

===============================

FModules

CONVERT_DATE_TO_INTERNAL

CONVERT_DATE_TO_EXTERNAL

===============================

Dynamically u can do by writing a program

Use any of the foll. FM

HRGPBS_HESA_DATE_FORMAT

Format a date valid for HESA: DD/MM/YYYY

HRGPBS_TPS_DATE_FORMAT

Format a date valid for TPS: DDMMYY

SLS_MISC_GET_USER_DATE_FORMAT

get the date format the user has defined as his/her default

========================================

REPORT ZES .

data: v_date type char10.

CALL FUNCTION 'HRGPBS_HESA_DATE_FORMAT'

EXPORTING

p_date = sy-datum

IMPORTING

DATESTRING = v_date.

replace all occurences of '/' in v_date with '.' .

write v_date.

hope it solves your problem. pls close the thread by allocating points if u satisfy with solutions.

Message was edited by: Eswar Kanakanti

Re: Date format

Former Member — Thu, 02 Mar 2006 09:03:53 GMT

Hi,

Try the FM: Try FM 'CONVERT_DATE_TO_EXTERNAL'

http://help.sap.com/saphelp_nw04/helpdata/en/07/d63a68db9110459d63c495b16f522e/content.htm


DATA: lv_date(10) type c,
      fi_date(10) type c.

lv_date = '2006.03.02'.

CONCATENATE lv_date+8(2) '.' lv_date+5(2) '.' lv_date+0(4) into fi_date.

write: fi_date.

OP: 02.03.2006

Best Regards,

Anjali

Re: Date format

Former Member — Thu, 02 Mar 2006 09:05:33 GMT

Hi los,

1. simple.

2. REPORT abc.

DATA : d1(10) TYPE c.

DATA : d2(10) TYPE c.

d1 = '2006.02.25'.

CONCATENATE d18(2) '.' d15(2) '.' d1(4) INTO d2.

WRITE d2.

regards,

amit m.

Re: Date format

hymavathi_oruganti — Thu, 02 Mar 2006 09:07:09 GMT

1.U CAN USE 'USING EDIT MASK' statement with write

write d using edit mask dd.mm.yyyy

2. or u can declare a char variable of 10

use concatenate statement

data: date(10).

concatenate d(2) '.' d2(2) '.' d4(4) into date

Message was edited by: Hymavathi Oruganti

Re: Date format

Former Member — Thu, 02 Mar 2006 09:12:45 GMT

OK, thanks a lot!

Re: Date format

Former Member — Thu, 02 Mar 2006 09:38:53 GMT

OK, now I have another problem.

I used "write" and it changed format to dd.mm.yyyy, but it inserts delimeter(.), so how can i delete the (.)?

Re: Date format

Former Member — Thu, 02 Mar 2006 09:52:20 GMT

Hi again,

1. simple.

data: m(10) type c.

m = '22.05.2006'.

<b>replace all occurrences of '.' in m with ''.</b>

write m.

regards,

amit m.

Re: Date format

hymavathi_oruganti — Thu, 02 Mar 2006 10:08:02 GMT

THEN WHILE WRITING WRITE STATEMEENT ITSELF, INSTEAD OF '.'

GIVE A SPACE

WRITE DATE USING EDIT MASK 'DD MM YYYY'

Re: Date format

Former Member — Thu, 02 Mar 2006 10:09:19 GMT

THANKS!

Re: Date format

Former Member — Thu, 02 Mar 2006 10:16:18 GMT

Hi,

1. As per the forum etiquette,

u may pls award points

to helpful answers by clicking the STAR

on the left of that reply.

regards,

amit m.

Re: Date format

vinod_gunaware2 — Tue, 07 Mar 2006 06:09:14 GMT

It show me completely solve query however the point for it is not yet updated.

Is pt assignment development not working properly?

Regards

Vinod