[SalesForce] What are the minimum and maximum valid dates in Salesforce

What are the minimum and maximum valid dates in Salesforce?

What is the valid date range in Apex, SOQL or SOAP API?

It is hard to find anything in the documentation

Best Answer

Initially I have found an answer here, but the link provided in that answer, was broken.

Finally found a corresponding valid link in the documentation

Minimum and Maximum Dates

Only dates within a certain range are valid. The earliest valid date is 1700-01-01T00:00:00Z GMT, or just after midnight on January 1, 1700. The latest valid date is 4000-12-31T00:00:00Z GMT, or just after midnight on December 31, 4000. These values are offset by your time zone. For example, in the Pacific time zone, the earliest valid date is 1699-12-31T16:00:00, or 4:00 PM on December 31, 1699.

Related Solutions

[SalesForce] Using Date in SOQL to get only records created on a certain date

A likely cause of this is implicit conversion of CreatedDate to a Date producing an unexpected result because of the timezone set for your user. According to this Gotcha: convertTimezone() must be used in SOQL Date functions dealing with Datetime blog post by my colleague, the right expression to use for the date part of the "where" is:

DAY_ONLY(convertTimezone(CreatedDate)) = :fromDate

[SalesForce] How to calculate duration between two dates(in months and days) using formula field

Neither formula will be perfectly correct. Depending on your tolerance, you might consider:

(date1 - date2) / 30.43685

This gives you the number of days divided by the number of average days in a month in an average year. I derived this value from 365.2422, the number of "sol days", divided by the number of calendar months, 12.

If you're looking for a ballbark estimate, 30 or 31 will give you slightly inaccurate results, with a drift of either 5 or 7 days per year, while using this more accurate number should keep the drift to about 1 day per year.

If you want more accuracy, you're probably better off in Apex Code, because the actual math would be very complicated to pull off in formulas.

Best Answer

Related Solutions

[SalesForce] Using Date in SOQL to get only records created on a certain date

[SalesForce] How to calculate duration between two dates(in months and days) using formula field

Related Topic