Did you know you can calculate the time between two dates with Podio even if you're using different units of time? Here's how to use this flexible, handy tool:
if ( @Date1 == 0) return 0;
var a = moment( @Date1 );
var b = moment( @Date2 );
var res = b.diff(a, 'days');
if (res < 0) { 0 } else { res};
Here’s the breakdown of what this all means:
“Date1” is where you enter your initial date (received) ; “Date2” is your subsequent date (delivery)
On the 4th line where it says: “days” you can switch that out with any measurement of time:
-
milliseconds
-
seconds
-
minutes
-
hours
-
days
-
weeks
-
months
-
years
It will automatically output the time between the into this unit!
Calculating only weekdays is a bit trickier since you have to subtract Saturday/Sunday. To calculate the number of WEEKdays between two date fields do this:
function workingDaysBetweenDates(@startDate, @endDate) {
// Validate input
if (@endDate < @startDate)
return 0;
// Calculate days between dates
var millisecondsPerDay = 86400 * 1000; // Day in milliseconds
@startDate.setHours(0,0,0,1); // Start just after midnight
@endDate.setHours(23,59,59,999); // End just before midnight
var diff = @endDate - startDate; // Milliseconds between datetime objects
var days = Math.ceil(diff / millisecondsPerDay);
// Subtract two weekend days for every week in between
var weeks = Math.floor(days / 7);
var days = days - (weeks * 2);
// Handle special cases
var startDay = @startDate.getDay();
var endDay = @endDate.getDay();
// Remove weekend not previously removed.
if (@startDay - @endDay > 1)
days = days - 2;
// Remove start day if span starts on Sunday but ends before Saturday
if (@startDay == 0 && @endDay != 6)
days = days - 1
// Remove end day if span ends on Saturday but starts after Sunday
if (@endDay == 6 && @startDay != 0)
days = days - 1
return days;
}
workingDaysBetweenDates( new Date(@StartDate) , new Date(@EndDate))
And there you have it! You have successfully calculated the number of weekdays. Now you have a variety of options for calculating time between two dates in Podio.
TECHeGO
Use Podio to calculate the time between two dates.
