problem with the format of date

Comments

• vampireeyes Member Posts: 33

  2005-05-30

  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... {
  ¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿

  0
• jpelaho Member Posts: 14

  2005-05-31

  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.

  0
• vampireeyes Member Posts: 33

  2005-05-31

  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... {
  ¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿

  0
• jpelaho Member Posts: 14

  2005-05-31

  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.

  0
• jpelaho Member Posts: 14

  2005-07-02

  I solved my problem by modifying the format in the System customisation menu
  
  Thank you to all.

  Jp.

  0