Date Time Utilities
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 between dates.
What's new in V5.0.0
- Converted to Mendix Studio Pro 10.24.17.
- Fixed MonthOfYear, which previously returned the day of the month instead of the month of the year. It now returns 1-12. If you were compensating for the old behaviour, remove that workaround.
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.
MonthOfYear:
Get the month of the current year (1-12).
Weeks:
CurrentWeekinMonth:
Get the current week of the month.
NoOfWeeksinMonth:
Get total number of weeks in a Month using a date value.
TotalWeeksinYear:
Get the total weeks in year using year value.
WeekOfYear:
Get the week of the current year.
Working Days:
WorkingDaysIncludingDates:
Get working days (excluding Saturday and Sunday) using start date and end date (Start and End date will be included in the working days).
WorkingDaysExcludingDates:
Get working days (excluding Saturday and Sunday) using start date and end date (Start and End date will not be included in the working days).
Typical usage scenario:
Useful in date scenarios of past dates, future dates and in business working days.
Features and limitations
1.Useful to get the start and end date of previous and next month.
2.Userful to get the Current week in month, Month of year and week of year.
3.Useful to get the working days including and excluding start and end date.
Dependencies
Mendix Studio Pro 10.24.17
Screenshots:
