[SalesForce] Date Calculation in Apex

I am lost on how to Calculate the difference between two dates (days):

temp_LatestGapLen = temp_PB_CurrSubBeg - temp_PrevSubEnd;

Left variable is defined as Integer, the other two are Dates. Error received is:

Error: Compile Error: Date arithmetic expressions must 
use Integer or Long arguments at line 449 column 53

Help? I can't find a reliable reference to this online in my searches despite how simple this seems. Is it implying you can only do date vs integer calculations, not date vs date??

Thanks so much.

Best Answer

Use daysBetween

date startDate = date.newInstance(2008, 1, 1);
date dueDate = date.newInstance(2008, 1, 30);
integer numberDaysDue = startDate.daysBetween(dueDate);

Here ist the doc: Date Methods

Related Solutions

[SalesForce] Formula to calculate time between two dates, Salesforce example broken

You are correct - Looking at the SFDC Object reference, Case.closedDate is a DateTime field so line 2 and line 4 will break

Looking at line 2 and line 4 - these are manipulating days, not seconds so I'd rewrite line 2 and line 4 as:

Line 2

( 5 * FLOOR( ( DATEVALUE(ClosedDate) - DATE( 1900, 1, 8) ) / 7) +

Line 4

MOD( DATEVALUE(ClosedDate) - DATE( 1900, 1, 8), 7) +

You should go to the doc and use the feedback form to point this out to SFDC

[SalesForce] Assigning a date value to a date field in Apex

In addition to Mark Pond's answer, you could also use:

registerDate = System.now(); //same as datetime.now( )
registerDate = System.today() or Date.today() //if you're not interested in time part, time part will be 00:00:00

And if you want to completely remove the time, use date formatting. Below example will give you only the date part.

registerDate = Datetime.now().format('MM-dd-yyyy');

Best Answer

Related Solutions

[SalesForce] Formula to calculate time between two dates, Salesforce example broken

[SalesForce] Assigning a date value to a date field in Apex

Related Topic