How do I convert a DateTime to a Date in Apex?

Call date() on the Datetime for the running user's time zone, or dateGmt() for GMT. Both are listed in the Apex Datetime class reference .

What does DATETIMEVALUE do in Salesforce?

It turns a Date or a "YYYY-MM-DD HH:MM:SS" text into a Date/Time. A Date becomes 12:00 AM GMT, which users see in their own time zone.

How do I get only the date from a DateTime in SOQL?

Use DAY_ONLY(CreatedDate). Wrap the field in convertTimezone() inside DAY_ONLY when you group or filter by the day your users see.

Why does DATEVALUE show the next day for some records?

Formulas convert Date/Time values in GMT, so an evening record in a US time zone can already be the next day in GMT. Salesforce's Date and Date/Time formula tipsheet explains the GMT storage.

Can a Salesforce formula read the user's time zone?

No. You can subtract a fixed offset, but daylight saving breaks it twice a year, so Salesforce recommends Apex for exact conversions.

Convert DateTime to Date in Salesforce: Formula, Apex, SOQL

DATEVALUE() takes a Date/Time value and returns only its Date:

DATEVALUE( CreatedDate )

It works in formula fields, validation rules, Flow formulas and report row-level formulas. In Apex you call date() on the Datetime, and in SOQL you wrap the field in DAY_ONLY().

Below is every way to convert DateTime to Date in Salesforce, with real output from our org and the time zone catch that moves late-evening records to the next day.

This Tutorial Covers: