Skip to Content

Date Format Issue while uploading to SQL Server Management Studio 2008 using DTW in SAP Business One Application

HI,


I am working on SAP B1 and have created an excel template using Data Transfer Workbench, so i could bulk upload the data on SQL Server Management Studio. I'm facing trouble while adding an entry/row which has dates in it.

The UDT's structure for that column is set to Date, I've also set the date's column data format to 'ddmmyy' in excel so that the data could be uploaded successfully.

Now the issue comes in some data values, for example:


begdate | enddate

311299 | 311200

After using DTW, and then quering the SAP B1 table in the sql server gives:


begdate | enddate

1999-12-31 00:00:00.000 | 2000-12-31 00:00:00.000

Though the true values should be:


begdate | enddate

9999-12-31 00:00:00.000 | 1900-12-31 00:00:00.000

Can someone please help me solving this problem? Appreciate your help 😊

Regards,

Amiruddin Ayaz

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Aug 27, 2015 at 01:38 PM

    Hi Amiruddin Ayaz,

    Please maintain BEGDAT and ENDDAT in below format in Excel.



    BEGDAT | ENDDAT

    31129999 | 31121900



    OR

    BEGDAT | ENDDAT

    99991231 | 19001231

    Hope this helps.

    Reward if helpful.

    Regards,

    Srinivas K

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 28, 2015 at 12:29 AM

    Hi,

    Pass in the values as 'yyyyMMdd' format.

    Regards

    Edy

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 28, 2015 at 05:40 AM

    Hi Amiruddin Ayaz,

    Please maintain BEGDAT and ENDDAT in below format in Excel.


    Try below format



    BEGDAT | ENDDAT

    31121900| 31129999


    Hope this helps.

    Reward if helpful.

    Regards,

    Srinivas K

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.