E r g e b n i s / R e s u l t
Rechnet die Differenz zwischen zwei Daten aus und gibt sie in Monaten
Calculate the difference in months between two dates
B e s c h r e i b u n g / D e s c r i p t i o n
Calculating the difference between two dates is not a function built in
to Open Access. This function returns the number of whole months
between two dates, in the range 0 - 11.
The dates passed to the function can be anyway around as the routine
calculates the difference rather than subtracting one from the other.
S y n t a x
Code:
value = call ('DATEDIF1' , datefld1 , datefld2) P a r a m e t e r
datefld1, datefld2 - any Open Access date
value - an integer number of months
R e t u r n s
An integer value.
B e i s p i e l / E x a m p l e
Code:
attach 'DATEDIF'
put call ('DATEDIF1' , sysdate , sysdate - 360) ! prints 11
detach 'DATEDIF' Q u e r v e r w e i s / R e f e r e n c e
DATEDIF2