Pages: 1
RSS
Two dates difference, A Macro to subtract two dates
 
Is there any macro I can use to get the difference between to given dates?

Per example:
Date 1: 17-12-2007 13:50:00
Date 2: 16-11-2007 13:00:00

Result: 1 month, 1 day and 50 minutes


thank you in advance!  
 
There's a %XMP_TimeDiff macro in the eXtended Macro Plugin, available at http://www.gaijin.at/thebat.php
Knowledge of the German language is an advantage for installing the plugin.
__________________________________
I'm just a user of The Bat! I don't work for Ritlabs.
 
Thank you, I have tried it, but this Macro doesn´t seems to work with TheBat v3.99.xx :(:(:(

Another solution, please?
 
Nobody knows....:(
 
I tried the %XMP_TimeDiff macro and it working just fine. Just to be sure, you need to install the XMP plugin into TB in order to get the macro functioning.
After I did that a quick template with this macro:
%XMP_TimeDiff("17-12-2007 13:50:00","16-11-2007 13:00:00",X)
gave me this result:
31 Tage, 50 Minuten

AFAIK There isn't any other way to achieve this result from within TB, though I don't know all available plugins, so there might be another one.
__________________________________
I'm just a user of The Bat! I don't work for Ritlabs.
 
Thank you Roelof Otten, Now it´s working....I have a problem with the local date representation. I was using the format specified in the program .chm:

  01.01.2004 12:00:00
and I have to change it si "spanish format":
  01/01/2004 12:00:00


It was a localization problem (and a .chm in german, wich I don´t undedrstand a word :()!!!

Now it´s working really fine!
Pages: 1