+ Start a Discussion
jontkjontk 

Date Time format error

Page 32 of the 6.0 API doc says that 2005-05-05T12:00:00 should be a valid date and time format but I get a malformed query error when I try this. Am I missing something obvious?

Thanks in advance.
Jon

select id,date__c from Contact where date__c = 2005-05-05T12:00:00ng>





ns1:MALFORMED_QUERY
MALFORMED_QUERY:
where date__c = 2005-05-05T12:00:00
^
ERROR at Row:1:Column:67
unexpected char: 0x?F


MALFORMED_QUERY

where date__c = 2005-05-05T12:00:00
^
ERROR at Row:1:Column:67
unexpected char: 0x?F
1
67



SuperfellSuperfell
The docs are wrong (i'll get that fixed), you have to use one of the formats that include a TZ offset.