Subtract two dates and convert the result into days

[perland]

Hello,

I have a search and report DataPage that I would like to show the difference between two dates in days. The start day will be new Date(), and the end date a time field in a table. Below is an outline of the code. Is there an easy way to do this?

Thank You.

var StartDate = new Date();

var EndDate = document.getElementById("InsertRecordpatient_status_change_timestamp").value;

Var NumberDays = StartDate-EndDate

document.write(NumberDays);

[Bangalore]

Hello,

If you are using a Search and Report Datapage, and if you have two date fields in the table associated with the Datapage, then you can use Calculated Fields to calculate the date difference. Please see this link to setup calculated fields in your Datapage:

http://howto.caspio.com/datapages/creat ... ed-fields/

The date difference function is :

Datediff(day,[@field:Date1],[@field:Date2])

Take a look at this link for more information on the Datediff function:
http://msdn.microsoft.com/en-us/library/ms189794.aspx

Thanks

[perland]

Thank You.

[DanielStay]

the link is dead! That's 5 in a row! arrrrrgh

[jonathanr]

Hi Dannno,

 

To improve our How-to documentation, we have created a new article for this issue.

 

Here is the link: http://howto.caspio.com/faq/reports-datapages/calculated-fields-and-datediff-function/

 

We apologize for the inconvenience. 

 

~Jonathan