|
|
|
|
|
The Calculate page for date time elements allows you to perform the following operations.
Date time operations
|
Operation |
Description |
|---|---|
|
- (difference) |
The difference between the date in the report and another specified date. |
|
- (difference in days) |
The number of days between the date in the report and another specified date. |
|
- (difference in months) |
The number of months between the date in the report and another specified date. |
|
- (difference in years) |
The number of years between the date in the report and another specified date. |
|
Add days |
Specify the number of days to add to a date. |
|
Add months |
Specify the number of months to add to a date. |
|
Add years |
Specify the number of years to add to a date. |
|
Earliest |
Determine the earliest date between the date in the report and another specified date. |
|
Latest |
Determine the latest date between the date in the report and another specified date. |
|
Year |
Extract the year value from a date. |
|
Month (number) |
Extract the month value from a date. |
|
Week |
Extract the week value from a date. |
|
Day |
Extract the day value from a date. |
|
Hour |
Extract the hour value from a date. |
|
Minute |
Extract the minute value from a date. |
|
Second |
Extract the seconds value from a date. |
| Copyright © 2012 - 2015 Oracle and/or its affiliates. All rights reserved. |
|---|