topic Chenge Date format in smartforms in Application Development and Automation Discussions

Chenge Date format in smartforms

Former Member — Mon, 07 Oct 2013 06:27:03 GMT

I want to convert date format

Example : 01.01.2000 convert it into 01.Jan.00

How i can get this?

Re: Chenge Date format in smartforms

Former Member — Mon, 07 Oct 2013 06:39:07 GMT

Hello Jaya,

you can try converting it by using

SET DATE MASK = 'DD.MMMM.YY'

Re: Chenge Date format in smartforms

Former Member — Mon, 07 Oct 2013 06:58:12 GMT

Formatting Date Fields: SET DATE MASK

To define the formatting of date fields, use the SET DATE MASK control
command. Executing this command causes all subsequent date fields to be printed
using the specified format.

Syntax:

/: SET DATE MASK = 'date_mask'

In the date mask, you can use the following codes:

DD: day (two digits)
DDD: day name - abbreviated
DDDD: day name - written out in full
MM: month (two digits)
MMM: month name - abbreviated
MMMM: month name - written out in full
YY: year (two digits)
YYYY: year (four digits)
LD: day (formatted as for the L option)
LM: month (formatted as for the L option)
LY: year (formatted as for the L option)

All other characters found in a date mask are interpreted as simple text and
are copied straight into the output.
Assuming the current system date is March 1st, 1997.

/: SET DATE MASK = 'Foster City, MM/DD/YY'
&DATE& -> Foster
City, 03/01/97
/: SET DATE MASK = 'MMMM DD, YYYY'
&DATE& -> March 01,
1997
The date mask may be reset to the default setting by using an empty
string:
/: SET DATE MASK = ' '

The abbreviated and full forms of the names of the days and months are stored
in the language dependent TTDTG table under the following keys:

%%SAPSCRIPT_DDD_dd: abbreviated day name

%%SAPSCRIPT_DDDD_dd: full form of day name
%%SAPSCRIPT_MMM_mm: abbreviated month name
%%SAPSCRIPT_MMMM_mm: full form of month name

dd: day number 01 = Monday,..., 07 = Sunday

mm: month number 01 = January,..., 12 = Decemberhttp://help.sap.com/saphelp_nw04/helpdata/EN/d1/8031dd454211d189710000e8322d00/frameset.htm

Re: Chenge Date format in smartforms

Former Member — Mon, 07 Oct 2013 07:00:32 GMT

Hi Jaya,

You can use the SET DATE MASK to change the date format in the Smartform output as indicated by Nicolas Glänzer.

Create code lines (before the node where you print the date) in the Smart Form and write the command to change the date format.

For printing the date as "01.Jan.00", you can use the below command.

SET DATE MASK = "DD.MMM.YY".

For reference you can see the documentation in the following link.

http://help.sap.com/saphelp_nw73ehp1/helpdata/en/4e/3663165fff02c9e10000000a15822b/content.htm

Regards,

Narayana Reddy A V L.

Re: Chenge Date format in smartforms

Former Member — Mon, 07 Oct 2013 07:10:07 GMT

Deara jaya Reddy,

please use the following code or make a funciton module and use it in command lines before the text in smart form you will get your result.

PARAMETERS: dat type sy-datum.

data : e_month type c LENGTH 2,

e_year type c LENGTH 4.

data: day type c LENGTH 2.

data: date TYPE c LENGTH 25.

data: MONTH_NAMES LIKE T247 OCCURS 0.

data: wa_month like LINE OF month_names.

day = dat+0(2).

CALL FUNCTION 'CACS_DATE_GET_YEAR_MONTH'

EXPORTING

I_DATE = dat

IMPORTING

E_MONTH = e_month

E_YEAR = e_year.

CALL FUNCTION 'MONTH_NAMES_GET'

EXPORTING

LANGUAGE = SY-LANGU

* IMPORTING

* RETURN_CODE =

TABLES

MONTH_NAMES = month_names

EXCEPTIONS

MONTH_NAMES_NOT_FOUND = 1

OTHERS = 2

IF SY-SUBRC <> 0.

* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

* WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

delete month_names where mnr ne e_month.

READ TABLE month_names into wa_month index 1.

CONCATENATE day '-' wa_month-ltx '-' e_year into date.

CONDENSE date.

write: date.

Re: Chenge Date format in smartforms

Former Member — Mon, 07 Oct 2013 09:25:18 GMT

Hi Jaya Reddy,

Please check the below link. You can find a similar discussion here.

http://scn.sap.com/thread/394228

Regards,

Riju Thomas.

Re: Chenge Date format in smartforms

Former Member — Mon, 07 Oct 2013 10:01:39 GMT

Hi Jaya,

You can achieve your object using table T247.

Algo for code will be:

let DATE = 07.10.2013

You can use table T247 Pass Spras = EN and MNR = '10' and fetch KTX field value.

This will give you Month name as OCT.

CONCATENATE '07.' KTX '.' date+8(2) into date1 RESPECTING BLANKS.

This will give you date as required.

Regards,

Jeetendra

Re: Chenge Date format in smartforms

Former Member — Tue, 08 Oct 2013 09:22:52 GMT

Hi Jaya,

You can also use FM 'CONVERSION_EXIT_SDATE_OUTPUT'.

EXAMPLE

DATA: INT_DATUM TYPE SY-DATUM VALUE '19940102',

EXT_DATUM(11) TYPE C.

CALL FUNCTION 'CONVERSION_EXIT_SDATE_OUTPUT'

EXPORTING

INPUT = INT_DATUM

IMPORTING

OUTPUT = EXT_DATUM.

Regards,

Anoop