function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
andy_candy_c 

Malformed Query using DateTime field

The following query gives me a Malformed Query exception with no further detail.

"select Email, FirstName, LastName, MailingCountry from Contact where LastModifiedDate > 2005-02-13T01:00:00 and Email != null"

I am developing on a Java 1.5 platform using Apache Axis 1.2RC2.

Anyone have any ideas what the problem may be?

andy_candy_c
Adding a Z to the end of the date field solved my problem, even though documentation doesn't specify this.
LupoLupo

I have your same problem... but even adding a "Z" at the end of date field the result is "malformed query"...

Have you an idea what I'm making wrong?

I'm using .Net Framework on win2000 pro system...
andy_candy_c
If you are querying a datetime field it seems you must have the hr, min and secs as well.

So my query had to be:

"select Email, FirstName, LastName, MailingCountry from Contact where LastModifiedDate > 2005-02-13T01:00:00Z and Email != null"