topic Re: date foramt in scripts in Application Development and Automation Discussions

date foramt in scripts

Former Member — Fri, 02 Jun 2006 05:41:21 GMT

Hi,

My requirement is to get the date(in scripts) like 20th May 2006 instead of 2006/05/20. How to get it? Can any one help me...

Re: date foramt in scripts

Former Member — Fri, 02 Jun 2006 05:43:29 GMT

Hi kishore,

1. U cannot do this directly .

2. in driver program, use

the FM

CONVERSION_EXIT_SDATE_OUTPUT

This will give ouptut in a variable in the format

20.MAY.2006

(u will have to write your own logic for

20th May 2006 )

(this <b>th</b> logic is very cumbersome)

3. This new variable, u can use in layout.

&newvariable&

regards,

amit m.

Re: date foramt in scripts

Former Member — Fri, 02 Jun 2006 05:44:32 GMT

use table t247 with elect logic...

parameters: date like sy-datum.

data: begin of itab occurs 0,

SPRAS type SPRAS,

MNR LIKE T247-MNR,

KTX LIKE T247-KTX,

LTX LIKE T247-LTX,

end of itab.

DATA : month LIKE T247-MNR.

DATA: YEAR(4).

DATA: FINAL(10).

MONTH = DATE+4(2).

YEAR = DATE+0(4).

select SINGLE * from t247 into itab where mnr = month

AND SPRAS = 'E'.

APPEND ITAB.

CONCATENATE ITAB-LTX YEAR INTO FINAL SEPARATED BY ''.

WRITE: FINAL.

Re: date foramt in scripts

Former Member — Fri, 02 Jun 2006 05:48:23 GMT

Hi kishore,

use this command in sapcript in the line before ur date..

/:SET DATE MASK = 'DD MMM YYYY'

Re: date foramt in scripts

Former Member — Fri, 02 Jun 2006 05:49:58 GMT

Hi Kishore,

Welcome to SDN.

You can do that.

Use this link.

http://help.sap.com/saphelp_erp2004/helpdata/en/d1/803411454211d189710000e8322d00/frameset.htm

Use the corresponding mask.

Thanks,

Susmitha.

Dont forget to rewards points for useful answers.

Re: date foramt in scripts

dani_mn — Fri, 02 Jun 2006 05:52:17 GMT

you can code your own function for this.

like.

CASE date+5(2).

When '01'.

datemonth = jan.

......

year will be copied as same. concatenate 'th' with day.

Regards,

Wasim Ahmed