problem with the format of date

jpelaho

I developed a program to import opportunities in CRM.
The format of date that I use is "yyyy-mm-dd HH:mm:ss"
The program succeeds in importing the data but CRM does not recognize this format when I open the card of opportunities

vampireeyes

my suggestion would be to check how the table saves the data.

if it only saves the yyyy-mm-dd just lose the time in ur entry.

there are of course several ways of using dates so... keep trying would be my guess.

just me thinking out loud... hope it helps

jpelaho

Thank you for your assistance.

The data are well recorded in the data base with the specified format.

But the problem is that looking at the summary of the opportunities, the date appeared as "dd/05/aaaa"; that is for example the date 31/05/2005 appeared as dd/05/aaaa. Looking at the detail of the opportunity 31/05/2005 appears as 05/31/2005 instead of 31/05/2005 rather.

How can I solve this problem?
It is possible to specify a precise format with the application ?

vampireeyes

well it could be that the dates are mixed up.

here in NL we write: 31-05-2005

American style is crossed

I.e. : 05/31/2005

maybe there is a clue there. just try to input in all formats

i.e. year first
day first
month first
day and month switched
with and without time

alas I have no answer but can only offer u this tip.

goodluck !

jpelaho

I already tested all these formats. The only formats which are accepted at the time of the migration are "yyyy-mm-dd HH:mm:ss" or "yyyy-mm-dd"
Thanks.

jpelaho

I solved my problem by modifying the format in the System customisation menu

Thank you to all.