# Calculations on date time elements

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