#73047 - 2003-02-13 12:25 AM
Find the number of days between 2 dates
|
toys4x4boys
Lurker
Registered: 2003-02-12
Posts: 2
Loc: Merseyside, UK
|
We use Kixtart 4.11 as part of out login script, one of the functions is to check the virus definitions dates to see of they are over 30 days old.
If they are it sends a mail to the helpdesk.
What I need is a way to find the number of days between two dates.
During my search I found this snippet,
$difference=JulianDate(@date)-JulianDate($defdate)
but there is not this feature in 4.11 , or at least not that I can find.
So whats the easiest way to find the number of days between 2 given dates ?
Def Date : 2003/02/05
Client Date : 2003/02/12
![[Confused]](images/icons/confused.gif)
|
|
Top
|
|
|
|
|
#73049 - 2003-02-12 02:42 PM
Re: Find the number of days between 2 dates
|
toys4x4boys
Lurker
Registered: 2003-02-12
Posts: 2
Loc: Merseyside, UK
|
Ended up with this which works ![[Eek!]](images/icons/shocked.gif)
;----- This compares the virus def date
;----- And the definitions date
;----- Returns the days between the two dates
Function JulianDate($TxDate) ; Assumes 4 digit year, M/D/Y or Y/M/D and / as delimiter
DIM $Year, $Month, $Day, $Pos
$Pos=INSTR($TxDate,"/")
If $Pos=5
$Year=0+SUBSTR($TxDate,1,4)
Else
$Month=0+SUBSTR($TxDate,1,$Pos-1)
EndIf
$TxDate=SUBSTR($TxDate,1+$Pos,10)
$Pos=INSTR($TxDate,"/")
If $Year
$Month=0+SUBSTR($TxDate,1,$Pos-1)
$Day=0+SUBSTR($TxDate,1+$Pos,2)
Else
$Day=0+SUBSTR($TxDate,1,$Pos-1)
$Year=0+SUBSTR($TxDate,1+$Pos,4)
EndIf
$JulianDate=367*$Year-7*($Year+(($Month+9)/12))/4-3*((($Year+($Month-9)/7)/100)+1)/4+275*$Month/9+$Day-678972
EndFunction
$daysbetween=JulianDate(@date)-JulianDate($defdates)
|
|
Top
|
|
|
|
Moderator: Glenn Barnas, NTDOC, Arend_, Jochen, Radimus, Allen, ShaneEP, Ruud van Velsen, Mart
|
0 registered
and 2220 anonymous users online.
|
|
|
