• Registered: 2014-12-02
  • Posts: 136

Topic: v1.49 Possible Bug

I have a table that has a date field and 8 real fields.  When I search records the date field will not display but the other real fields show as expected.  When I try to edit a record, I get an error that says the '01/01/2015' is not a valid date and time.  Although, this is defined as a date field.  Not sure why I cannot display the date nor edit using a form.

Please advise.  I have imported the data into my database.

Rob

  • Registered: 2014-02-14
  • Posts: 10,294

Re: v1.49 Possible Bug

I think you have wrong format of date, when importing data.

the correct format of date field is:
2015-02-18 00:00:00.000

Dmitry.
  • Registered: 2014-12-02
  • Posts: 136

Re: v1.49 Possible Bug

DriveSoft wrote:

I think you have wrong format of date, when importing data.

the correct format of date field is:
2015-02-18 00:00:00.000

Yes, that was the issue.  I had to format the column using excel using a custom format "yyyy-mm-dd hh:mm:ss.000".