How do I query records created today in SOQL?

Use the TODAY date literal on the CreatedDate field, for example SELECT Id, Name FROM Account WHERE CreatedDate = TODAY. Do not put quotes around TODAY. Use YESTERDAY in the same way for the previous day.

How do I query records from the last N days in SOQL?

Use LAST_N_DAYS:n, for example WHERE CreatedDate = LAST_N_DAYS:7. The range includes today. If you need only one specific day, use N_DAYS_AGO:n instead.

How do I sort SOQL results by created date?

Add ORDER BY CreatedDate to the query. Results are oldest first by default, so add DESC to see the newest records first, and add LIMIT to keep only the top rows.

How do I query the recycle bin in Salesforce with SOQL?

Add ALL ROWS to a query in Apex and filter with IsDeleted = true. In Workbench, tick Include deleted and archived records, and in the API use the queryAll endpoint. The Developer Console Query Editor does not accept ALL ROWS.

What is the difference between CreatedDate, LastModifiedDate and SystemModstamp?

CreatedDate is set once when the record is created. LastModifiedDate changes when a user or process edits the record, while SystemModstamp also changes for system updates, which is why integrations often use it.

Does SOQL TODAY use UTC or my time zone?

CreatedDate values are stored and returned in UTC, so the Query Editor shows UTC times. For exact day boundaries, query an explicit UTC range such as CreatedDate >= 2026-10-11T00:00:00Z AND CreatedDate < 2026-10-12T00:00:00Z and compare it with the literal in your org.

Query Records Created Today or Yesterday with SOQL

To query records created today or yesterday in Salesforce, filter on the CreatedDate field with a date literal: WHERE CreatedDate = TODAY returns today’s records and WHERE CreatedDate = YESTERDAY returns yesterday’s. Both are SOQL date literals, so you write them without quotes, and they work for any standard or custom object that has a CreatedDate field.

In this tutorial, I will show how to use the SOQL created date filters for today, yesterday and the last N days, how CreatedDate differs from LastModifiedDate and SystemModstamp, how to sort by created date, how to find deleted records from the recycle bin, and what happens with time zones. Every query runs in the Developer Console, in Workbench or in Apex.