Welcome

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
TOP
TOP
Include Page
CP Script
CP Script

Excerpt

When completing mobility activities in KA131-HED - Mobility of higher education students and staff supported by internal policy funds projects, the Duration Calculated (days) field is available in the Duration section of the mobility activity details screen and automatically calculated using the start and end date of the mobility activity provided. The technical calculations applied depend on the activity type of the mobility activity and if the Long-term mobility activity flag, if available, is checked. 

For Student Mobility Activities (Studies and Traineeships) - Long-Term Activity:

  • The number of days is calculated using the assumption that each month has 30 days, and a year consists of 360 days. The technical formula applied is as follows:
    • Duration in Days=(YEAR(ENDDATE) - YEAR(STARTDATE)) * 360 + (MONTH(ENDDATE) - MONTH(STARTDATE)) * 30 + (IF(AND(MONTH(ENDDATE)=2;OR(DAY(ENDDATE)=28;DAY(ENDDATE)=29));30;IF(DAY(ENDDATE) = 31;, 30;, DAY(ENDDATE)))) - IF(DAY(STARTDATE) = 31;, 30;, DAY(STARTDATE))) + 1
  • In this scenario, February is considered to have 30 days.

For Student Mobility Activities (Studies and Traineeships) - Non-Long-Term Activity:

  • The duration in days of the mobility activity is calculated simply as ENDDATE - STARTDATE+1.
  • In this case, February is considered to have 28 days.

For Staff Mobility Activities (Teaching and Training):

  • The duration in days of the mobility activity is also calculated as ENDDATE - STARTDATE+1.
  • Similar to student activities, February is considered to have 28 days in this scenario.


Expand
titleClick here to view example calculations.

Example 1: HE-SMS and HE-SMT with the Long-Term Activity flag checked

  • START DATE: 01/01/2023
  • END DATE: 15/04/2023
  • Calculation:
    • First, we calculate the number of years between the start and end dates: (2023 - 2023) = 0 years.
    • Next, we calculate the number of months: (4 - 1) = 3 months.
    • We consider February as having 30 days.
    • Finally, we calculate the number of days: (15 - 1) + 1 = 15 days.
  • Result: 0 years + 3 months + 15 days = 105 days.

Example 2: HE-SMS and HE-SMT with the Long-Term Activity flag unchecked

  • START DATE: 18/02/2023
  • END DATE: 11/03/2023
  • Calculation:
    • The start date is subtracted from the end date and 1 is added to account for both the start and end days.
    • Result: (2023-03-11) - (2023-02-18) + 1 = 22 days.

Example 3: HE-STA and HE-STT

  • START DATE: 24/02/2023
  • END DATE: 13/03/2023
  • Calculation:
    • The start date is subtracted from the end date and 1 is added to account for both the start and end days.
    • Result: (2023-03-13) - (2023-02-24) + 1 = 18 days.


Content by Label
showLabelsfalse
max100
showSpacefalse
sorttitle
cqllabel = "bm" and label = "eac_naitdoc_search" and label in ("3_eac_naitdoc","4_eac_naitdoc") and label = "mobility_activities" and space = currentSpace() and type = "page"