You need to sign in to do that
Don't have an account?
JTec
Queries with date field
Hi,
We are trying to do queries filtering by a date field, the query is something like this:
"Select count() From Lead l where l.Status = 'Qualified' and LeadSource in ('Marketing','Database','Research') and OwnerId in ('00520000000kwBIAAY') and ConvertedDate >= 2008-01-01 and ConvertedDate <= 2008-01-31"
But this query don't count field with ConvertedDate = 2008-01-31, is this a error? It is correcly? we are doing tests and we have saw that don't filter registers when we filter for ConvertedDate = "some value"
???????
Thanks
We are trying to do queries filtering by a date field, the query is something like this:
"Select count() From Lead l where l.Status = 'Qualified' and LeadSource in ('Marketing','Database','Research') and OwnerId in ('00520000000kwBIAAY') and ConvertedDate >= 2008-01-01 and ConvertedDate <= 2008-01-31"
But this query don't count field with ConvertedDate = 2008-01-31, is this a error? It is correcly? we are doing tests and we have saw that don't filter registers when we filter for ConvertedDate = "some value"
???????
Thanks
Thanks
But what can we do if we want to filter for = 2008-2-1? Have we to say <2008-2-2 and >2008-1-31???
This is not the correct form to work with dates.
I will open the case and if sfdc tell me anything I will update this post.