cancel
Showing results for 
Search instead for 
Did you mean: 

date format in sap scripts

Former Member
0 Kudos

Hi experts,

How can we format the date display in SAP scripts ?

Thanks.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi

Use the command

SET DATE MASK = '<format>'

like format

'MMMM DD,YYYY' to print March 01,2007

so set the format as per your requirement and print the date

Reward points for useful Answers

Regards

Anji

former_member588853
Active Contributor
0 Kudos

Hi,

Formatting Date Fields: SET DATE MASK Edit section

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 = December

reward if useful

regards,

nazeer

Message was edited by:

nazeer shaik