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