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 © 2014 Oracle and/or its affiliates. All rights reserved. |
---|