topic Change in date format in sap script in Application Development and Automation Discussions

Change in date format in sap script

Former Member — Mon, 21 Mar 2005 15:36:56 GMT

Hi ,

i am working on the check layout. Here the date format that we want is mm.dd.yyyy. I changed the SAP system setting to mm.dd.yyyy. Now in the application side, every where we can see this format. Even in the table level we can see the same format. But still in the layut it printing as dd.mm.yyyy.

Is there a way where i can change for date format to mm.dd.yyyy for REGUP-BLDAT field.

Its really urgent.

Thanks .

Re: Change in date format in sap script

RichHeilman — Mon, 21 Mar 2005 15:44:02 GMT

Yes, although I'm a little confused why its not taking your default system setting.

You can use the SET DATE MASK statement in your sapscript.



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

maybe this statement is already there in the sapscript which is causing it to display the other way. If so, then remove this statment



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

Regards,

Rich Heilman

Re: Change in date format in sap script

Former Member — Mon, 21 Mar 2005 15:55:31 GMT

I tried to locate this command. But i couldnt find it.

I also tried to enter this new command to have

/: set date mask as mm.dd.yyyy,

AS &regup-bldat&

but still its not accepting. It is giving the same format in the output, as

dd.mm.yyyy

Thanks,

Re: Change in date format in sap script

Former Member — Mon, 21 Mar 2005 17:07:08 GMT

A quick solution for your problem if it's urgent:

1) Split the date

2) Concatenate between '/'

3) Print the Char Variable.

With this you can print your sapscript and gain more time to figure it out what's wrong.

As Rich sayas it's a confused thing the reason that is not taking your default system setting.

Re: Change in date format in sap script

Former Member — Tue, 22 Mar 2005 16:06:12 GMT

Hi Carlos,

I checked up the main program. There i can see the date is hardcodded as DD.mm.YYYY. The entries for the same are at many places. So instead of changing the std, i think we can split and concatenate and u suggested.

When i try to split the date '20050321'. I dont want to hard code it as split after 5.

Is there a way by whichi can split it as first 4 digits, then 2 digits and then last 2 digits.

Pls suggest.

Thanks.

Re: Change in date format in sap script

RichHeilman — Tue, 22 Mar 2005 16:11:27 GMT

Use offsets......



Data: today(10) type c.

concatenate sy-datum+4(2) '/'
            sy-datum+6(2) '/'
            sy-datum+0(4)
                  into today.

Regards,

Rich Heilman

Re: Change in date format in sap script

Former Member — Tue, 22 Mar 2005 16:33:39 GMT

Hi,

I tried it, its not working some how.

All i need here to split based on the offset.

And later i will concatenate once i have dd mm and yyyy in three variables.

Thanks,

Re: Change in date format in sap script

RichHeilman — Tue, 22 Mar 2005 17:36:05 GMT

My code should have worked for you.......post your code.

Regards,

Rich Heilman

Re: Change in date format in sap script

Former Member — Tue, 22 Mar 2005 18:40:22 GMT

Hi,

I am working for the layout.

so i have created a subroutine to capture the date and print.

the code in the form is

data tdate type d.

WRITE ITAB-ZALDT to NDATE. " ndate = '20010521'

concatenate ndate+4(2) '/'

ndate+6(2) '/'

ndate+0(4)

into tdate.

Its really urgent

Thanks

Re: Change in date format in sap script

RichHeilman — Tue, 22 Mar 2005 18:47:03 GMT

Change this



data tdate type d.

to this



data tdate(10) type c.

Regards,

Rich Heilman

Re: Change in date format in sap script

Former Member — Tue, 22 Mar 2005 18:53:43 GMT

Hi,

tried the saem set of code, its not working.

I also created a new program to see if the concatenate function works,

here is the complete code.

REPORT ZNEW .

data ndate type d value '20010521'.

data tD type C.

WRITE ' HELLO'.

concatenate NDATE+4(2) '/'

ndate+6(2) '/'

ndate+0(4)

into td.

write : ndate , tD.

output is

HELLO 05212001 0

Re: Change in date format in sap script

RichHeilman — Tue, 22 Mar 2005 19:01:29 GMT

change your code to be like this.....



data ndate type d value '20010521'.
data tD<b>(10)</b> type C.

concatenate NDATE+4(2) '/'
ndate+6(2) '/'
ndate+0(4)
into td.

write : ndate , tD.

Regards,

Rich Heilman

Re: Change in date format in sap script

Former Member — Tue, 22 Mar 2005 20:08:43 GMT

Hi Rich,

Thanks for the help. Your code is wokring, i was making a very silly mistake.

Thanks again,

Re: Change in date format in sap script

Former Member — Tue, 22 Mar 2005 20:23:27 GMT

You have a sapscript instruction to set the language of the sapscript .

If you select country DE Deutschland you use the format for this country points of miles ,dates and points of decimals

The instruction is set country