Date Time Functions

Content Type: Module
Categories:

Overview

Date Time Functions:

This module helps to get Next Month's start and end date, Previous Month start and end date, Current week in a month, Month of the year, No. of weeks in a month, week of year and working days(Business Days) between dates.

Days:

  • NoOfDaysinMonth

Months:

  • NextMonthStartDate
  • NextMonthEndDate
  • PreviousMonthStartDate
  • PreviousMonthEndDate
  • MonthStartDate
  • MonthEndDate

Weeks:

  • CurrentWeekinMonth
  • NoOfWeeksinMonth
  • TotalWeeksinYear

Business Days:

  • GetBusinessDays

Documentation

Date Time Functions:

This module helps to get Next Month's start and end date, Previous Month start and end date, Current week in a month, Month of the year, No. of weeks in a month, week of year and working days(Business Days) between dates.

Days:

  • NoOfDaysinMonth:

Get total number of days in month using year and month value.

Months:

  • NextMonthStartDate:

Get the Next month Start date.

  • NextMonthEndDate:

Get the Next month End date.

  • PreviousMonthStartDate:

Get the Previous month Start date.

  • PreviousMonthEndDate:

Get the Previous month End date.

  • MonthStartDate:

Get Month Start date using year and month value.

  • MonthEndDate:

Get Month End date using year and month value.

Weeks:

  • CurrentWeekinMonth:

Get the current week of the month.

  • NoOfWeeksinMonth:

Get total number of weeks in a Month.

  • TotalWeeksinYear:

Get the total weeks in year using year value.

Business Days:

  • GetBusinessDays:

Get working days (excluding Saturday and Sunday) using start date and end date.

Dependencies

  • Mendix modeler 9.12.4.

Known bugs

None

Releases

Version: 1.0.0
Framework Version: 9.12.4
Release Notes: Added the Date Time Functions