problem with the format of date

jpelaho
jpelaho Member Posts: 14
edited 2005-07-02 in Dynamics CRM
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
Jp.

Comments

  • vampireeyes
    vampireeyes Member Posts: 33
    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
    ???????????????????????
    { Intuitively wrong... {
    ¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿
  • jpelaho
    jpelaho Member Posts: 14
    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 ?
    Jp.
  • vampireeyes
    vampireeyes Member Posts: 33
    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 !
    ???????????????????????
    { Intuitively wrong... {
    ¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿
  • jpelaho
    jpelaho Member Posts: 14
    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.
    Jp.
  • jpelaho
    jpelaho Member Posts: 14
    I solved my problem by modifying the format in the System customisation menu

    Thank you to all.
    Jp.

Categories