Date Conversions and Storage
As described in
Date Functions, date fields can be used in equations. For example, to increment a date a certain number of days, you would select a date field and add X, where X represents the number of days to add to the date. Prior to running calculations,
Windchill Risk and Reliability converts dates to the number of days since midnight of December 30, 1899.
The way in which results from date calculations are stored depends on the type of field selected for Result Field in the Calculation Editor pane.
• If a text or numeric field is selected, results are stored as numeric values, where the unit is always the number of days.
• If a date field is selected, results are converted back to dates.
For example, suppose the equation entered is 1/10/04 + 7. If the result is stored in a numeric or text field, it is 37683. If the result is stored in a date field, it is 1/17/04.