Date format: DD-MMM-YYYY

[Former Member]

Hi,

I am using SAPscipt in arabic language and printing a date field in DD-MMM-YYYY format in english.

It is printing in expected format,except month,which is in arabic.

Day and year are coming in english by default,but month is coming in arabic,even when i have used SET COUNTRY ' ' in print program and in SAP script,brfore printing the date.

Can you please give me some inputs for printing month also in english.

Thanks & Regards

Seshagiri

[Former Member · Accepted solution]

Hello,

Check this.

Date Mask 

To format date fields, use the SAPscript SET DATE MASK command. Executing this command causes all subsequent date fields to be printed with the specified formatting. 

Syntax

/: SET DATE MASK = 'date_mask' 

The following templates may be used in the date mask: 

DD day (two digits) 
DDD name of day (abbreviated) 
DDDD name of day (written out in full)
MM month (two digits) 
MMM name of month (abbreviated)
MMMM name of month (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)

Any other characters occurring in the mask are interpreted as simple text and are copied directly to the output. 



Assuming a current system date of March 1st, 1997. 

/: SET DATE MASK = 'Foster City, MM.DD.YY' 
&DATE& -> Foster City, 03.01.97 
&DATE(Z)& -> Foster City, 3.1.97 

/: SET DATE MASK = 'MMMM DD, YYYY' 
&DATE& -> March 01, 1997 

You can revert to the standard setting by using the SET DATE MASK command again with an empty string in place of the date mask: 

/: SET DATE MASK = ' ' 

Regards,

Vasanth

[Former Member · Accepted solution]

Hi Vasanth,

Thank you for your quick reply.

Here in my case i am already suing /: SET DATE MASK = 'DD-MMM-YYYY' and getting required format correctly,but except the month in arabic,which should be in english.

Please note my script form is in arabic and i can not use script in english,as i have to print some other information in arabic.

Please suggest.

Thanks

Seshagiri

[Former Member]

Hi All,

Thank you for your inputs,but unfortunately my issue was not solved.I have resolved wilth my own logic by capturing the month name in print program.

Ex: If month = 1,i am storing the month name as 'Jan' ,if '2' ,then 'Feb' etc.,

I am using this name in script code for printing,between date and year.

Thanks & regards

Seshagiri.

[Former Member]

/: SET DATE MASK = 'YYYYMMDD'

then you can get the data by date format YYYYMMDD

thus you can convert it according to your any request

after your convert you can use

/: SET DATE MASK = ' ' to restore the original format

[Former Member]

Hi,

As you have used SET Country it will print the form in Arabic launguage as your format is DD-MMM-YYYY.

If you use format DD-MM-YYYY, it will print the whole date in English.

As according to me it will display it in Arabic only. Maybe you should try changing the format.

Sushil