Interval type value
| Description
|
---|---|
yyyy
| Extracts the year
|
q
| Quarter (the result is
1, 2, 3 or 4)
|
m
| Month (the result is
from 1 to 12)
|
y
| Day of year (1 to 365
or 366 in a leap year)
|
d
| Day part of the date
(1 to 31)
|
w
| Day of week (1 to 7
with the result depending on firstDayOfWeek)
|
ww
| Week of year (1 to 53
with firstDayOfWeek and firstWeekOfYear determining the exact days of the first
calendar week of the year)
|
h
| Extracts the hour part
of the given DateTime (0 to 23)
|
n
| Minute part (0 to 59)
|
s
| Second part (0 to 59)
|
DateDiff ("d", #10/7/1999#, #10/10/1999#)
DateDiff ("yyyy", #10/7/1999#, #2/10/2005#)
DateDiff ("yyyy", #12/31/1999#, #1/1/2000#)
DateDiff ("yyyy", #1/1/1999#, #12/31/1999#)
DateDiff ("q", #10/6/1999#, #5/20/2003#)
DateDiff ("q", #3/31/1999#, #4/1/1999#)
DateDiff ("q", #1/1/1999#, #3/31/1999#)
DateDiff ("m", #3/15/1999#, #7/13/1999#)
DateDiff ("w", #10/19/1999#, #10/25/1999#)
DateDiff ("w", #10/19/1999#, #10/26/1999#)
DateDiff ("ww", #10/5/1999#, #10/29/1999#, crWednesday)
DateDiff ("ww", #10/6/1999#, #10/29/1999#, crWednesday)
DateDiff ("ww", #10/5/1999#, #10/27/1999#, crWednesday)
Local DateTimeVar d1 := {Orders.Order Date}; Local DateTimeVar d2 := {Orders.Ship Date}; DateDiff ("d", d1, d2) - DateDiff ("ww", d1, d2, crSaturday) - DateDiff ("ww", d1, d2, crSunday)
SAP BusinessObjects http://www.sap.com/sapbusinessobjects/ Support services http://service.sap.com/bosap-support/ Product Documentation on the Web http://help.sap.com/ |