topic Re: Changing the date format in Scripts in Application Development and Automation Discussions

Changing the date format in Scripts

Former Member — Mon, 25 Sep 2006 18:15:55 GMT

Hi Friends,

I am using SAP scripts to print PO and the PO is printing the delvy date in dd.mm.yyyy format. The delvy date here is 10 char length and needs to be printed in mm/dd/yyyy. How can I write this logic in the text editor?

Thanks,

Raj

Re: Changing the date format in Scripts

Former Member — Mon, 25 Sep 2006 18:18:29 GMT

/: SET DATE MASK = ‘MM/DD/YYYY’

&V_DATE&

/: SET DATE MASK = ‘ ‘ <--TO switch off the date mask

But i am not very sure will this work for your requirement,as you said its 10 character field,so i dont know exactly whether this works correctly or not.

else,

you can use OFFSET of that 10 char variable, to print the way how you want

* &V_DATE3(2)& / &V_DATE0(2)& / &V_DATE+5(4)&

month date year

but make sure your date format always should be dd.mm.yyyy . here i have taken V_DATE as a date with 10 character length.

Regards,

Srikanth

Message was edited by: Srikanth Kidambi

Re: Changing the date format in Scripts

Former Member — Mon, 25 Sep 2006 18:18:49 GMT

use command set date mask __/__/____.

in ur script editor.

Regards

Re: Changing the date format in Scripts

Former Member — Mon, 25 Sep 2006 18:18:53 GMT

Hi raj,

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)

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

Regards

Sudheer

Re: Changing the date format in Scripts

RichHeilman — Mon, 25 Sep 2006 18:19:48 GMT

Please see the following......



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)

<b>/: SET DATE MASK = 'MM/DD/YYYY' &DATE& -> 09/26/2006</b>

Regards,

Rich Heilman

Re: Changing the date format in Scripts

Former Member — Mon, 25 Sep 2006 18:38:01 GMT

I tried this but did not work. I have the date field next to a different field. I added this syntax in the next line and did not work.

Thanks,

Raj

Re: Changing the date format in Scripts

Former Member — Mon, 25 Sep 2006 18:40:46 GMT

Hi Raj,

You need to place SET DATE MASK statement before you use date field in your script editor.

/: SET DATE MASK = 'MM/DD/YYYY'

/: &V_DATE&

If you need to switch off this masking, just use

/: SET DATE MASK = ' '

Thanks,

Vinay

Re: Changing the date format in Scripts

RichHeilman — Mon, 25 Sep 2006 18:42:17 GMT

Put the SET DATE MASK statement before using the date field in your script.

Regards,

Rich Heilman

Re: Changing the date format in Scripts

Former Member — Mon, 25 Sep 2006 19:01:42 GMT

Thanks Friends. I got it solved.

I've awarded points to all.

Thanks,

Raj