Centre d'assistance Gustav

Parcourez ou recherchez nos rubriques d'aide.

  1. Centre d'assistance Gustav
  2. English version
  3. Configures

Calculation-Date

S’abonner

Date Calculation
Date calculations follow the same rules as Number calculations, with a few exceptions:

  • They cannot perform aggregation (total/last/first/avg), so they cannot use variables in dependents.

  • They cannot use number variables.

  • Date-type variables available only for date calculations cannot have default values.

Time Value Display Format
Time values should be displayed according to the following formats, depending on the context:

  1. Format DD/HH: Displays days and hours.
    Display rules:

  • If the number of days is non-zero and the number of hours is non-zero, days and hours are displayed in the format DD/HH.

  • If the number of days is non-zero but hours are zero, only days are displayed.

  • If the number of days is zero, only hours are displayed.

  1. Format HH/MM: Displays hours and minutes.
    Display rules:

  • If the number of hours is non-zero and the number of minutes is non-zero, hours and minutes are displayed in the format HH/MM.

  • If the number of hours is non-zero but minutes are zero, only hours are displayed.

  • If the number of hours is zero, only minutes are displayed.

  1. Format MM: Displays minutes only.
    Display rules:

  • The value includes only minutes, which are displayed in the MM format.

  • This format is used when the value contains neither hours nor days.

Date Format as the Resulting Value of the Calculation

Date Format: Displays only the date resulting from the calculation.
Display rule:

  • The calculated date is displayed.

  • If hours are present, they are simply removed.

Date/Time Format: Displays the date and time resulting from the calculation.
Display rule:

  • The calculated date and time are displayed.

image (18).jpg

Formula Format
The calculation logic consists of defining the variables to use and integrating them into the formula. For example: EndDate - StartDate.

Adding Values (days/hours/minutes)
To add values such as days, hours, or minutes, a special format is used with specific indicators:

  • Days: $##J (e.g., $7J)
    Possible indicators: J, j, D, d

  • Hours: $##H (e.g., $18H)
    Possible indicators: H, h

  • Minutes: $##M (e.g., $45M)
    Possible indicators: M, m

Example of formula format usage:

image (19).png