Go Back > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 71

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 17th July 2019, 10:43
pegaga1979 pegaga1979 is offline
Senior Member
Join Date: Oct 2008
Posts: 170
pegaga1979 is on a distinguished road
Baan: Baan V - DB: SQL - OS: WINDOWS 2003
Date format different in some rows when download to Excel
Baan: Infor ERP 10.1 (FP7)
C/S: None/Unknown

Hi experts,

i have designed a query to download inventory transaction history.
when i download to excel, some of the row have different format of date.
for example:
Actual Log Date
6/10/2019 14:46
13-06-19 19:14:22
28-06-19 17:24:52
29-06-19 12:13:04
6/11/2019 18:39
6/11/2019 18:39
6/12/2019 11:59

21-06-19 17:17:20
19-06-19 16:26:34
19-06-19 16:28:52

It happen sometimes. Does anyone knows why and how i can prevent it.
it give us trouble same when to do analysis.

Thank you.
Reply With Quote
Old 17th July 2019, 13:22
mark_h's Avatar
mark_h mark_h is offline
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,320
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Is it that way in the table? Are you using a baan easy sql query or a session(like a report session)?

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
Old 18th July 2019, 08:48
oirfeodent's Avatar
oirfeodent oirfeodent is offline
Join Date: Jun 2016
Posts: 70
oirfeodent is on a distinguished road
Baan: Baan - DB: DB - OS: OS
Originally Posted by pegaga1979 View Post
6/10/2019 14:46
13-06-19 19:14:22
It seems the one which is colored is converted to a proper excel date object.
And the next one is stored as a text object.

Do you have a sample to attach?
Preferably the raw data(Which gets converted to Excel) and the Excel file... where the problem is visible.

Reply With Quote
Sponsored Links

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
convert date to utc date format yogesh kapil Tools Development 4 28th June 2012 16:30
Multiple date formats & currency formats by user. kphipps Tools Administration & Installation 6 9th November 2005 14:19

All times are GMT +2. The time now is 05:25.

©2001-2018 - -