[V4RB] Date-Time format problems?

[Carsten Friehe]

Hi!

I am setting the DateTime format to the following at database Creation:
      mDatabaseNew.DateSep = "."
      mDatabaseNew.DateFormat = EVDateFormat.kMDY
      mDatabaseNew.TimeSep = ":"

In my application I am doing the following:

---------
  Parameter.Append Format(Datum.Day, "00") + "." + Format(Datum.Month,
"00") + "." + Format(Datum.Year, "00") + " " + Format(Datum.Hour, "00") +
":" + Format(Datum.Minute, "00") + ":" + Format(Datum.Second, "00") + ":000"

  res = pGlob.mDatabase.SqlExecute("Update Newsserver set DatumAbruf = :1
where Kontoname = '" + Newsservername + "'", Parameter)
---------

DatumAbruf  is a DateTime field.

I am getting the following error:
------
402694:Date-time value "30.04.2007 22:28:23:000" is invalid. Boundary check
error.
------

If I look with ViSQL into the database I am getting the following value
"00.00.0000 00:00:00:000", so the format of the date-time value must be ok.
I don't know why this isn't working correctly.

Best Regards,
Carsten