Einzelnen Beitrag anzeigen
Alt 31.05.2007, 16:40   #17
RKabis
Registrierter Benutzer
Beschreibung vorhanden QTR3

E r g e b n i s / R e s u l t

Liefert die Anzahl der Tage von einem vorhergehenden Vierteltag
Return the number of days from the previous quarter day

B e s c h r e i b u n g / D e s c r i p t i o n

The procedure accepts a date and returns the number of days since the
previous quarter day.
The quarter days (used in leasehold / service accounts) are -
25th March
26th June
29th September
25th December
So, given a date of 28/03/1996 an integer value of 3 will be returned.

S y n t a x

Code:
value = call ('QTR2' , datefld)
P a r a m e t e r

datefld - Any valid Open Access date.

R e t u r n s

An integer number of days.

B e i s p i e l / E x a m p l e

Code:
attach 'DATEDIF'
put call ('QTR3' , sysdate) ! prints the number of days since
! the last quarter day
detach 'DATEDIF'
Q u e r v e r w e i s / R e f e r e n c e
QTR4
RKabis ist offline   Mit Zitat antworten