+ Start a Discussion

# of Days displayed

Hey guys,


I'm trying to add a number of days calculation in my Visualforce page, and this calculation is basically counting the number of days left to the end of a process.


I'm working with a date/time field, axns.Finish_date_time__c, so I use the ROUND() function to calculate the number of days only.


Here is the formula that I use to calculate the number of days left for my process:




This formula works well, but for some reason when it is equal to 10 days it shows the number in the following manner: 1E+1



Is there a way to display this number as 10?



Thank you,




Did you try to use function "daysBetween"?

This return an integer when compare 2 Date variables, for example:

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

In your case:

date startDate = axns.Finish_date_time__c;
date dueDate = DATEVALUE(NOW());
integer numberDaysDue = startDate.daysBetween(dueDate);


This works for you?



Your sample code would work in the apex controller. 


But, I'm trying to perform this calculation on the client side, on my visualforce page.






Change the #day to String . It should works