Difference btw two dates

[abiodunode]

Hello ALL,

I have two dates objects and i try to calculate the date interval so that I get no of days.
I have been struggling with it for some time now.
On loading the page, the calculated field is at 0.
Once i change the date, it turns to "NaN".

Attached is the picture.

What am i doing wrong?

I have " CheckedOutDate - CheckedInDate " on the calculated field.

Thanks.

[binque]

Re: Difference btw two dates

Ran into the same problem and had to write an XBASIC function that was called from an AJAX CALLBACK.

In my case, I had two days that were seperated by, as much as ten years. I needed the number of days in each 6 month period to calculate up to 21 different interest rates (required under MI state Law for judgments).

It worked great and was a wonderful exercise for me to use alot of different Xbasic file functions, and other XBASIC functions. As a bonus, I go to do a nice AJAX CALLBACK.

[agillbb]

Re: Difference btw two dates

I recommend you do it clientside (possibly using the onchange field events) to trigger a js function call.
You would define your js function in the definitions area.
To see what js code you might put in the function, see http://youropensource.com/projects/7...-in-javascript
Remember to use your A5 .getValue functions to grab the two date strings instead of getElementById as shown in the example.

[GGandhi]

Re: Difference btw two dates

hello

i am not sure if you are using sql backend, if you do then,
usually the calculated field need not be stored in the table definition
the field Number_Of_Nights can be calculated in the definition for the grid using
DaysBetweenDates(Date1 as D, Date2 as D) function which is available in the expression builder.
every time you change the dates and save the Number_Of_Nights will recalculate itself.

[Jim Coltz]

Re: Difference btw two dates

Since it looks like you're using a dialog and calendar objects you can do this. In the calculated field expression add:

days(yourStartCalendar'sControlName,YourEndCalendarsControlName)

Then in the javascript functions area define a function:

function days(a,b){
	if (a.length > 0 && b.length > 0){
		var x = new Date(a);
		var y = new Date(b);
		var z = Math.floor((y.getTime() - x.getTime()) / (1000*60*60*24))
		return z
	}else{
		return "Please select a start and end date!";
	}
}

Note with the dialog's calendar controls you need to either specify default value, like "=date(()" so the function has defaults to work with our use a test like I did and prompt the user to select dates.

Sample is attached.

[abiodunode]

Re: Difference btw two dates

Waoh!!!
Thanks everyone.
Jim, thanks a lot as I have been able to follow your example and it sorted me out. I do appreciate.
Once again, my special thanks to everyone for your suggestion.