+ Start a Discussion
intern24intern24 

Help with three variables to refine a search

Hi, I was wondering if anyone could help me with a soql query? I was wonder if you can use three variables to refine a single soql query. I want to pass a Name, Start Date and End Date so I can only show John Doe, 8/12/09, 8/19/09.  Can i do this with one query or would i have to use several queries. 

 

Thanks for any help you can give

imuino2imuino2

Sure you can here you have an example i did try:

 

Select a.Name From Account a Where a.Name = 'Acme' And a.CreatedDate < 2009-10-01T00:00:00.000Z And a.CreatedDate > 2006-10-01T00:00:00.000Z

 

Ignacio.