topic Re: Date format change in the sapscript in Application Development and Automation Discussions

Date format change in the sapscript

Former Member — Mon, 22 Dec 2008 11:38:18 GMT

Hi,

I have DATE format, like, YYYY/MM/DD, so, I need to convert it to DD/MM/YYYY in SAPSCRIPT.

How will u do that...

Re: Date format change in the sapscript

Former Member — Mon, 22 Dec 2008 11:44:44 GMT

use this function in your print program 'TZ_SYSTEM_TO_LOCAL' to get the date in your local format.

alternately what you can do is that use SET DATE MASK control command like

SET DATE MASK = Walldorf, den DD.MM.YYYY

&SYST-DATUM& --> Walldorf 01.01.2008

hope this helps

regards

Aakash Banga

Re: Date format change in the sapscript

SuhaSaha — Mon, 22 Dec 2008 11:49:45 GMT

Hello Dorothy,

The Date can be formatted using SET DATE MASK command.

In the SAPScript editor use the following command:

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

Hope this is clear to you.

BR,

Suhas

Re: Date format change in the sapscript

Former Member — Mon, 22 Dec 2008 11:53:17 GMT

Hi Raj,

SET DATE MASK command is for that perpose.

Regards,

Pravin

Re: Date format change in the sapscript

former_member585060 — Mon, 22 Dec 2008 11:54:17 GMT

Hi,

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

P1 &DATE&

Regards

Bala Krishna

Re: Date format change in the sapscript

Former Member — Mon, 22 Dec 2008 12:00:35 GMT

Hi ,

Change the date format according to your country specific and put SET COUNTRY 'country name' statement in script editor.

Re: Date format change in the sapscript

Former Member — Mon, 22 Dec 2008 12:01:21 GMT

please explain more

Re: Date format change in the sapscript

Former Member — Mon, 22 Dec 2008 12:02:45 GMT

Please search more.

Reported to SCN for rule violations

Re: Date format change in the sapscript

Former Member — Mon, 22 Dec 2008 12:10:59 GMT

hi,,

SEARCH IN SCN with SET DATE MASK.

make habbit for search in SCN before posting

thanks

Sachin

Re: Date format change in the sapscript

Former Member — Mon, 22 Dec 2008 12:12:45 GMT

I got it

Re: Date format change in the sapscript

kmoore007 — Tue, 18 Mar 2014 11:46:07 GMT

This is controlled with a configuration setting the the country. Look in the IMG under SAP NetWeaver->General Settings->Set Countries.

Re: Date format change in the sapscript

Former Member — Tue, 30 Jun 2015 17:28:01 GMT

Hi Suhas, know it is an old post. I am trying a simple thing. In my SAPscript i want to add (date) however when it returns to SAP it uses a wrong date format.

30-06-2015

I need it to send to SAP

30.06.2015

I copied the /: SET DATE MASK = 'DD.MM.YYYY' into my script, however it gives a Error: expected statement

Hope you can help and sorry if it is a stupid question 🙂

I have added my full script here

If Not IsObject(application) Then
   Set SapGuiAuto = GetObject("SAPGUI")
   Set application = SapGuiAuto.GetScriptingEngine
End If
If Not IsObject(connection) Then
   Set connection = application.Children(0)
End If
If Not IsObject(session) Then
   Set session    = connection.Children(0)
End If
If IsObject(WScript) Then
   WScript.ConnectObject session,     "on"
   WScript.ConnectObject application, "on"
End If

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

session.findById("wnd[0]").maximize
session.findById("wnd[0]/tbar[0]/okcd").text = "/nTransaction"
session.findById("wnd[0]").sendVKey 0
session.findById("wnd[0]/usr/txtSELECTION-SDAT").text = (DATE)
session.findById("wnd[0]/usr/txtSELECTION-STIME").text = "00:00:00"
session.findById("wnd[0]/usr/txtSELECTION-SREADTI").text = "06:00:00"
session.findById("wnd[0]/usr/txtSELECTION-SREADTI").setFocus
session.findById("wnd[0]/usr/txtSELECTION-SREADTI").caretPosition = 8
session.findById("wnd[0]").sendVKey 0
session.findById("wnd[0]/tbar[1]/btn[20]").press
session.findById("wnd[1]/usr/subSUBSCREEN_STEPLOOP:SAPLSPO5:0150/sub:SAPLSPO5:0150/radSPOPLI-SELFLAG[1,0]").select
session.findById("wnd[1]/usr/subSUBSCREEN_STEPLOOP:SAPLSPO5:0150/sub:SAPLSPO5:0150/radSPOPLI-SELFLAG[1,0]").setFocus
session.findById("wnd[1]/tbar[0]/btn[0]").press
session.findById("wnd[1]/usr/ctxtDY_FILENAME").text = "STAD_master.txt"
session.findById("wnd[1]/usr/ctxtDY_FILENAME").caretPosition = 15
session.findById("wnd[1]/tbar[0]/btn[7]").press
session.findById("wnd[0]/tbar[0]/btn[15]").press