You need to sign in to do that
Don't have an account?
intern24
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
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.