How to? date1 - date2 = number of days

[Charles G]

How would it be best be done?

dates are in the form of m/d e.g. 9/8 for September 8th.

some are also m/d/y if it's next year.

thanks in advance.

 

[Charles Dye]

Use @DATE to convert each to a julian, and subtract?

 

[vefatica]

Here's a start. But the date formats will need to be standardized. @MAKEAGE has a second parameter that lets you specify one of seven date formats

v:\> function days `%@eval[(%@makeage[%2]-%@makeage[%1]) / (10000000*60*60*24)]`

v:\> echo %@days[2016-06-16,2016-08-11]
56

v:\> echo %@days[2016-06-16,2017-08-11]
421

 

[vefatica]

My first one was faulty. This is better and lets you use mm/dd/yy.

v:\> function days `%@eval[(%@makeage[%2,,1]-%@makeage[%1,,1]) / (10000000*60*60*24)]`

v:\> echo %@days[8/11/16,8/11/17]
365

 

[Joe Caverly]

The VBScript DateDiff function is a solution that can be used with TCC;

@setlocal
@echo off
setdos /X-5
echo dtm1="01-Jan-16" > %@path[%_batchname]\dd.vbs
echo dtm2="%_Day-%_Monthf-%_Year" >> %@path[%_batchname]\dd.vbs
echo WScript.Echo "Difference between " & dtm1 & " and " & dtm2 >> %@path[%_batchname]\dd.vbs
echo intMonthsDifferent=DateDiff("d", dtm1, dtm2) >> %@path[%_batchname]\dd.vbs
echo WScript.Echo intMonthsDifferent >> %@path[%_batchname]\dd.vbs
setdos /X0
iff exist %@path[%_batchname]\dd.vbs then
  cscript //nologo %@path[%_batchname]\dd.vbs
  del /q %@path[%_batchname]\dd.vbs
else
  echo dd.btm - Error in creating %@path[%_batchname]\dd.vbs
endiff
endlocal

More info on the VBScript DateDiff function->: [title]

Joe

 

[Charles G]

My first one was faulty. This is better and lets you use mm/dd/yy.

v:\> function days `%@eval[(%@makeage[%2,,1]-%@makeage[%1,,1]) / (10000000*60*60*24)]`

v:\> echo %@days[8/11/16,8/11/17]
365

The *60*60*24 is obvious but why the 10000000 ?

 

[Charles Dye]

The *60*60*24 is obvious but why the 10000000 ?

Windows file age functions use 100ns ticks: ten-millionths of a second.

 

[Charles G]

Windows file age functions use 100ns ticks: ten-millionths of a second.

ns = nanosecond? or was that supposed to be ms = miliseconds?

 

[Charles Dye]

ns = nanosecond? or was that supposed to be ms = miliseconds?

Nanoseconds: FILETIME structure
The actual resolution used to record times may be far less.

 

[Charles G]

Here's a start. But the date formats will need to be standardized. @MAKEAGE has a second parameter that lets you specify one of seven date formats

v:\> function days `%@eval[(%@makeage[%2]-%@makeage[%1]) / (10000000*60*60*24)]`

v:\> echo %@days[2016-06-16,2016-08-11]
56

v:\> echo %@days[2016-06-16,2017-08-11]
421

I like the function days above. How about similar functions xxx for function name

@xxx[date,days] = returns date that is + or - days from specified date

 

[Charles Dye]

I like the function days above. How about similar functions xxx for function name

@xxx[date,days] = returns date that is + or - days from specified date

Like this? @DATEPLUS
Oh yeah; and also @DAYS