Erasmus+ & European Solidarity Corps guides


Welcome


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(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.


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.


Expand all   Collapse all