function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
The NewbieThe Newbie 

Help with SOQL query between dates

Hello everyone,

I need help with getting the data from 22-01-2020 till 22-01-2021, i have wriiten SOQL query but not working

SELECT CaseNumber, CreatedDate, Issue1__C,Issue1__C, Cause__C FROM Case Where CreatedDate >= 22-01-2020 AND CreatedDate <= 22-01-2021

Please help me with solution guys
SwethaSwetha (Salesforce Developers) 
What results are you seeing with the above query? (expected vs actual)?

See related: https://salesforce.stackexchange.com/questions/381132/soql-to-get-all-records-with-in-a-given-date-range