You need to sign in to do that
Don't have an account?
picker
Proper Date Format for a Query
I am trying to execute a select stmt where i filter on the date:
select Id,Name,Type,ParentId,BillingStreet,BillingCity,BillingState,BillingPostalCode,BillingCountry,ShippingStreet,ShippingCity,ShippingState,ShippingPostalCode,ShippingCountry,Phone,Fax,AccountNumber,Website,Sic,Industry,AnnualRevenue,NumberOfEmployees,Ownership,TickerSymbol,Description,Rating,Site,OwnerId,CreatedDate,CreatedById,LastModifiedDate,LastModifiedById,SystemModstamp,SLAExpirationDate__c,SLASerialNumber__c,NumberofLocations__c,SLA__c,CustomerPriority__c,UpsellOpportunity__c,Active__c from Account where LastModifiedDate >= 2006-06-09T12:00:00+0000
Same query works if i leave off:
where LastModifiedDate >= 2006-06-09T12:00:00+0000
Is this a valid date format?
Superfell
The +0000 part is not valid it should be +00:00 or just Z
picker
Excellent. Thank you Simon.