Changing the date when downloading into Excel using ws_download

When I download the data into Excel using ws_download, the date field, which is defined as character type in the...

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

internal table, does not display the leading zero.

E.g. It displays as 9/28/2004. Is it possible to display this as 09/28/2004? The internal table that is passed to the FM WS_DOWNLOAD has correct date value as '09/28/2004.'
You don't say what parameters you are using for WS_DOWNLOAD. I did a quick test, and find that for WK1 and ASC, the leading zero remains. This leads me to conclude that it is the formatting of the cell in excel that is causing the leading zero to be suppressed.

This was last published in August 2004

Related Q&A from Matthew Billingham

Getting data to show in an SAP ALV Grid

An SAP user is trying to run a report in an SAP ALV Grid online and wants to know how to get the data in the report to appear along with the header. Continue Reading

Transferring data to new sales orders in SAP VA01

An SAP user needs to transfer customer purchase order spreadsheet data to SAP VA01 to create a new sales order. Continue Reading

Changing all SAP user account passwords from one location

An SAP user needs information on how to change the password on several SAP user accounts from a central location. Continue Reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our SAP administration / development experts

View all SAP administration / development questions and answers

SearchERP

Workday to acquire Adaptive Insights for $1.55 billion

Workday says its acquisition of Adaptive Insights, a financial planning and modeling system, will save it two years of ...

Oracle claims it can cut ERP system migration costs by 30%

A migration can cost millions, but Oracle believes its new automation and integration tools can significantly reduce the cost of ...

Key enterprise accounting software features and benefits

To find the best enterprise accounting software, businesses must outline specific criteria and compare those criteria against ...

SearchOracle

AI-for-IT-operations tools map Vegas systems to Oracle ERP

Mapping IoT activity and other IT data to Oracle ERP is the task Las Vegas set for FixStream's AIOps platform in an effort to ...

Oracle 18c features give DBAs incremental database capabilities

Oracle Database 18c is really another version of 12c Release 2 with a different name. It doesn't contain major new features, but ...

Cloud workloads see gradual uptake, but miles to go for databases

A picture of steady but not rapid migration to the cloud by Oracle users emerged at Collaborate 18, with database vets saying ...

SearchDataManagement

Hortonworks cloud options grow via Google, Microsoft, IBM

Hortonworks now supports Google Cloud Storage and has also broadened cloud deals with Microsoft and IBM, aiming to increase cloud...

Evolving data integration strategies target new analytics needs

Most companies don't have a shortage of data, but it's often stored in siloed systems or inconsistent formats -- problems that ...

What goes into a customer analytics data integration framework

Customer data integration is a minefield for IT teams to navigate. But incorporating a set of core technical functions into an ...

SearchAWS

Use service-linked IAM roles to simplify user permissions

While AWS IAM enables control over a cloud environment, it can become a management nightmare. Automate part of this process via ...

Don't overestimate the benefits of serverless computing

It's natural to be curious about new technologies, but the hype around serverless computing far outweighs its practical ...

AWS low-code strategy hones in on back-end services

AWS has yet to unveil a native and general-purpose low-code platform, but some of its services, such as Lex and Sumerian, seem to...

SearchBusinessAnalytics

Data-driven strategy grooms dog care franchise for growth

Camp Bow Wow is growing its day care and boarding business for dogs with the help of a data-driven approach that's powered by a ...

Tableau acquisition of MIT AI startup aims at smarter BI software

Tableau acquires AI startup Empirical Systems in a plan to provide users with automated data modeling capabilities and enable ...

Choosing the right data discovery platform for the enterprise

Obviously, cost and scalability factor into data discovery platform buying decisions, but other features, like visualizations and...

SearchCRM

Banking blockchain part of Pega Infinity platform reboot

This Pipeline podcast features a not-so-serious Q&A with Pegasystems CMO Tom Libretto covering Journey albums, blockchain hype ...

Adobe-Microsoft partnership adds key integrations

Adobe brings its Document Cloud to Microsoft Office 365 and Dynamics 365, making it easier for licensees of both to quickly ...

Data migration software coming for SAP CRM

At Sapphire Now, SAP unveiled C/4HANA, a suite of applications that brings together ERP and CRM. To make it easier to switch, ...

SearchContentManagement

SharePoint hub sites raises migration questions among users

In the newest rev of SharePoint Online, what used to be sub-sites are now new freestanding sites. This change and others may ...

Cloud DAM platforms vs. on premises for digital asset management

Learn about digital asset management and how cloud DAM democratizes media management and delivery across the enterprise while ...

Box workflow gets upgrade with Progressly purchase

Box is hoping to upgrade its workflow capabilities by adding the startup Progressly to its team, while also still partnering with...

SearchHRSoftware

News roundup: TriNet software targets professional services

New specialized products include TriNet software for professional services, QuickBooks payroll for contractors and a ...

AI can reduce workplace bias, says CEO of leading HR group

AI technology may help HR reduce workplace bias, according to Johnny Taylor, president and CEO of the Society for Human Resource ...

How to create an effective employee retention plan

The unemployment rate is low, and your workers are likely being courted by other companies. Here's how to create retention ...

Related Resources

Dig Deeper on SAP ABAP

Related Q&A from Matthew Billingham

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.