Einzelnen Beitrag anzeigen
Alt 31.05.2007, 16:38   #16
RKabis
Registrierter Benutzer
Beschreibung vorhanden QTR2

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

Liefert den kommenden Vierteltag für ein Datum
Return the next quarter day for a date

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 next 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/04/1996 a date of 26/06/1996 will be returned.

S y n t a x

Code:
qtrday = 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

A quarter day as a date.

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

Code:
attach 'DATEDIF'
put call ('QTR2' , sysdate) ! prints the next quarter day
detach 'DATEDIF'
Q u e r v e r w e i s / R e f e r e n c e

QTR1
RKabis ist offline   Mit Zitat antworten