Einzelnen Beitrag anzeigen
Alt 31.05.2007, 12:23   #13
RKabis
Registrierter Benutzer
Beschreibung vorhanden DATEDIF3

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

Fügt eine exakte Anzahl von Monaten einem Datum hinzu
Add an exact number of months to 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

This function takes a date and adds a number of months passed to the
function. As the function adds the value directly to the month and does
not add 30 or 31 days then you can be assured that the day number will
stay the same.

S y n t a x

Code:
date = call ('DATEDIF3' , datefld , months)
P a r a m e t e r

datefld - any Open Access date
months - an integer number of months

R e t u r n s

A date field.

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

Code:
attach 'DATEDIF'
put call ('DATEDIF3' , sysdate , 1) ! prints next month's date
put call ('DATEDIF3' , sysdate , -1) ! prints last month's date
detach 'DATEDIF'
Q u e r v e r w e i s / R e f e r e n c e

DATEDIF4
RKabis ist offline   Mit Zitat antworten