function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
pickerpicker 

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?
SuperfellSuperfell
The +0000 part is not valid it should be +00:00 or just Z
pickerpicker
Excellent.  Thank you Simon.