Date Time Functions

Content Type: Module
Categories: Utility

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

Releases

Version: 2.0.0
Framework Version: 9.24.18
Release Notes: **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.24.18. **Screenshots:** ![DateTimeFunctions](https://github.com/user-attachments/assets/f921b6dc-e729-4c41-ab64-1e229a96c924)
Version: 1.0.0
Framework Version: 9.12.4
Release Notes: Added the Date Time Functions