Hi BaaNFriends,

I am working BaaN Vc.

I have a big problem with the dates in BaaN, It happens me because, one external application puts information directly in my oracle database, in this information that program is saving information with dates & times, for example that external application save one row with 15/01/2009 16:27:00, but when I see in ttaad4500 appears me 11:27:00. I have looked for in BaaNBoard forums and I understand now that BaaN that it applies the difference with the greenwich meridian (I am GMT-05:00). But in this case I don't want that BaaN works in this way for this case.

What should I do to fix this, without I change the baan configuration, and I don't damage the configuration for the rest of the application?

Thank you.

I faced this once(on ERPLN ) and I did not find a parameter on baan to change this. The solution: the external application inputs the data with the GMT =P

Hi,

Thank you

I don't understand you, because the external application makes a insert into on baan tables.

What do you said me, when you told me "The solution: the external application inputs the data with the GMT =P"?

How should the external application make it to obtain GMT =P in "Insert into" sql instruction?

Thak you for your help........

Another option could be to add a Time Zone field to the table, if it is allowed in your company to modify table definitions. You can then use some date/time functions to convert the time to your time zone or you could read time always with the time zone.
I understand this sounds simple but involves too many changes as you have to modify all scripts which use the date to consider the time zone. But this should fix the issue forever :)