topic Re: urg:reg:date conversion in Application Development and Automation Discussions

urg:reg:date conversion

Former Member — Wed, 11 Apr 2007 10:00:14 GMT

how to convert yyyymmdd to dd/mm/yy

Re: urg:reg:date conversion

Former Member — Wed, 11 Apr 2007 10:03:03 GMT

concatenate sy-datum0(4) '/' sy-datum4(2) '/' sy-datum+6(2) into g_dat.

Re: urg:reg:date conversion

Former Member — Wed, 11 Apr 2007 10:03:24 GMT

data : date type sy-datum.

data : date1(10) type c.

date = sy-datum.

concatenate date6(2) '/' date 4(2) '/' date2(2) into date1.

Now date1 caontains the date in ur required format.

Regards,

Sujatha.

Message was edited by:

Sujatha Reddy

Re: urg:reg:date conversion

anversha_s — Wed, 11 Apr 2007 10:04:22 GMT

hi,

chk this.

HRGPBS_HESA_DATE_FORMAT

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

data:date_form type CHAR10.

call function 'HRGPBS_HESA_DATE_FORMAT'
exporting
P_DATE = sy-datum
importing
DATESTRING = date_form
exceptions
others = 1.


write : date_form.

Another FM - CONVERT_DATE_TO_EXTERNAL

Rgds

Anver

Re: urg:reg:date conversion

Former Member — Wed, 11 Apr 2007 10:05:40 GMT

Hi,

Use the concatenation

data g_date(8).

concatenate

sy-datum6(2) '/' sy-datum4(2) '/' sy-datum+2(2) to g_date.

reward if useful

regards,

ANJI

Re: urg:reg:date conversion

Former Member — Wed, 11 Apr 2007 10:07:40 GMT

hi Varun,

try the following logic:


data:
   date1 type sy-datum,
   date2(10).

data1 = sy-datum.
concatenate date1+6(2) date1+4(2) date1+0(4) into date2
separated by '/'.

write: date1, / date2.

Hope this helps,

Sajan Joseph.

Re: urg:reg:date conversion

Former Member — Wed, 11 Apr 2007 10:09:32 GMT

TRY THIS

DATA : V_CHAR LIKE SY-DATUM VALUE '20070410'.

DATA : YEAR(2),

MON(2),

DAY(2),

DATE(8).

YEAR = V_CHAR+2(2).

MON = V_CHAR+4(2).

DAY = V_CHAR+6(2).

CONCATENATE DAY MON YEAR INTO DATE SEPARATED BY '/'.

WRITE : / DATE.

Re: urg:reg:date conversion

Former Member — Wed, 11 Apr 2007 10:10:15 GMT

Hi Varun,

Check this info.

Use function module CONVERT_DATE_TO_EXTERNAL. This will convert the date to the user specific format. So if your user specific format is mm/dd/yyyy, then this is all you need.

Hope this resolves your query.

Reward all the helpful answers.

Regards

Re: urg:reg:date conversion

anversha_s — Wed, 11 Apr 2007 11:11:22 GMT

Dear Varun,

Please close all your open threads if u got the correct solution. Otherwise revert back.

Regards

Anversha