Expressions for Date attributes

The following examples are expressions for Date attributes.
Table 1. Expressions for Date attributes
Expression Description Example Result
=0 The result for the expression, =0 must be a blank value
=365*24 One year after the reference date in the UTC (+0) time zone Depends on the current time zone of the server. For example,
  • In the EST timezone (-05:00), the time point will be 1970-12-31 19:00 with the result 1970-12-31.
  • In the CET time zone (+01:00), the time point will be 1971-01-01 01:00 with the result 1971-01-01.
.
='Start Date' + 'Man Hours' / 40 * 168 Calculates an approximate end date for a project where one person works full time without vacation. Start Date: 2004-08-01. Man Hours: 80 2004-08-15

Feedback