Calculate days/Weeks between 2 Dates?

[StingRay]

Is there a Way to calculate the days or Weeks between 2 Dates?

Just with the Standard extensions and maybe a Little math?!?

Thanks for your help!

[RhysD]

You can use a timestamp to achieve this I think there are a few timestamp extensions floating around. They basically return a long number that is based on the current date and time. To get the difference you just subtract the old timestamp from the new one. I think it returns milliseconds or something; then convert those to the numbers you need.

[StingRay]

I think of converting to Android, so there's no timestamp ext for that

[StingRay]

No, i have a app where you setup and Start and end Date and After this the app Shows a individual Countdown (Real Time)

[Popcorn]

MMF really lacks in this department!
However, it is possible to do without extensions.

Eliyahu came up with this exellent formula for me:

((Int((Year-2001)*(365.25))+Min(1, Max(0, Month-2))*Max(0, (1-Year mod 4))+Month *30+(Month+Month/8)/2-2*Max(Min((Month-2), 1), 0)+Day)*24*60)+Hour*60+Minute

It converts a date into minutes. Leap years are taken into account as well. If you convert two dates you can then find the difference.

I've attached an example


Of course, if anyone could make this into an extension it would be awesome. As it is now, it is quite a bit of work when setting up new dates to compare.

[StingRay]

Thanks, Popcorn!

[tompa]

shouldn't be a problem

extracting weeks from days
A = days between dates

A / 7 = weeks to event
A mod 7 = days to event
or A - (7 * (A / 7)) = days to event (fusion logic)

great work popcorn!

[conceptgame]

Note that this formula is not valid forever: 2100 is not a leap year for example. But I don't think that it matters for your application.
Leap Year is: (Year mod 4 == 0 AND Year mod 100 !=0) OR Year mod 400 == 0 and not only Year mod 4 == 0 as it is in the formula.