PDA

View Full Version : Calculating date differences


EX_BCBS
March 11th, 2010, 07:03 AM
Is there a way to compare a date from the data to the current system date and figure out the difference? I would like to calculate the time past from a last visit. Thank you.

esmith
March 11th, 2010, 07:47 AM
Sure. What format is the date in the data?

EX_BCBS
March 11th, 2010, 07:50 AM
Mm/dd/yyyy

esmith
March 11th, 2010, 01:32 PM
//function copied from Paul McFedries' (http://www.mcfedries.com/JavaScript/DaysBetween.asp) website
function days_between(date1, date2) {

// The number of milliseconds in one day
var ONE_DAY = 1000 * 60 * 60 * 24

// Convert both dates to milliseconds
var date1_ms = date1.getTime()
var date2_ms = date2.getTime()

// Calculate the difference in milliseconds
var difference_ms = Math.abs(date1_ms - date2_ms)

// Convert back to days and return
return Math.round(difference_ms/ONE_DAY)

}

//get current date
var today = new Date();

//convert data for last visit to date format
var lastVisit = new Date(Field("Date"));

//determine days between two dates
var totalDays = days_between(today, lastVisit);

return totalDays;

EX_BCBS
March 15th, 2010, 06:15 AM
Perfect, thank you!

mhilger
March 15th, 2010, 07:34 AM
Great script! Thanks for posting this, Eric.