Salesforce Developer Community

hello,

sorry for my terrible english.

I've two questions for you.

1st question: I've to make a query on "Account" table.

This is my query:

select Name, BillingStreet, BillingCity, BillingPostalCode from Account where Codice_Conto__c = '76113'

ok. My query works well.

But now I need to filter data by LastModifiedDate. For example I need to get results where LastModifiedDate is greater than 1 dec 2004.

What is the right sintax to do this?

I tried this sintax:

select Name, BillingStreet, BillingCity, BillingPostalCode from Account where Codice_Conto__c = '76113' and LastModifiedDate > 2001-12-01

and many others... but it doesn't works...

2nd question: Can I delete a record on sforce using queries?

for example, can I use a command like this:

delete from Account where Codice_Conto__c = '76113'

Thank you very mutch for any help,

Francesco C.

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?