on 08-27-2015 12:43 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Pass in the values as 'yyyyMMdd' format.
Regards
Edy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.