Wednesday, January 30, 2013

SBL-DAT-00359: The value '%1' cannot be converted to a date time value.

SBL-DAT-00359: The value '%1' cannot be converted to a date time value.
Some time when we do query in siebel on Date field  of applet with following value (Including Time)

> "1/24/2012 11:00 AM" AND < "1/25/2012 11:00 AM"

We get the SBL-DAT-00359 Error. Work Around is, use following format Hour:Minute:Second

> "1/24/2012 12:00:00 AM" AND < "1/25/2012 12:00:00 AM"


Posted by

1 comment:

  1. Unknown7/02/2018 5:04 PM

    how do i correctly feed in the format dd/mm/yyyy

    ReplyDelete

Subscribe to: Post Comments (Atom)