Month (Property)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Range of dates
Managing the months and years
Operators available for the months
Calculating the last day of the month
Calculating a payment date at 90 days (end of month)
Calculating the end of a 30-day period

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Month (Property)

In french: Mois

..Month is used to:

Retrieve the month from a Date or DateTime variable.
Modify the month in a Date or DateTime variable.
Retrieve the month from a Date item (in "Simple date" or "Date and Time" format).
Modify the month in a Date item (in "Simple Date" or "Date and Time" format).

Remark: ..Month simplifies the operations performed on dates (add a month, etc.).

Reminder: The Date items are used to manage:

the simple dates "Year - Month - Day" (YYYYMMDD format)
the dates and times "Year - Month - Day - Hours - Minutes - Seconds - Milliseconds" (YYYYMMDDHHMMSSLLL format)
the durations "Number of days - Number of hours - Number of minutes - Number of seconds - Number of milliseconds" (+DHHMMSSLLL format)

Versions 18 and later

This property is now available in Windows Store Apps mode.

New in version 18

This property is now available in Windows Store Apps mode.

Versions 21 and later

This property is now available in Universal Windows 10 App mode.

New in version 21

This property is now available in Universal Windows 10 App mode.

Example

// Operations on a Date variable
StartDate is Date = "20011212"
// Add 1 month to the date
StartDate..Month++
// Modify the month
StartDate..Month = 5

// Operations on an item
Work.StartDate = "20011212"
// Add 1 month to the date
Work.StartDate..Month++
// Modify the month
Work.StartDate..Month = 5

Syntax

Finding out the month in a Date or DateTime variable Hide the details

<Result> = <Date>..Month

<Result>: Integer

Month on 2 digits.

<Date>: Date or DateTime

Name of the Date or DateTime variable to use.

Modifying the month in a Date or DateTime variable Hide the details

<Date>..Month = <New month>

<Date>: Date or DateTime

Name of the Date or DateTime variable to use.

<New month>: Integer or character string

New month expressed in numbers (included between 1 and 12). Replaces the month in the specified date.

Finding out the month in a Date item (in "Simple date" or "Date and Time" format) Hide the details

<Result> = <Data file>.<Item>..Month

<Result>: Integer

Month on 2 digits.

<Data file>: Character string (with or without quotes)

Name of data file used. This name was defined in the data model editor or by the File description type.

<Item>: Character string (with or without quotes)

Name of item used. This name was defined in the data model editor or by the Item description type.

Modifying the month in a Date item (in "Simple date" or "Date and Time" format) Hide the details

<Data file>.<Item>..Month = <New month>

<Data file>: Character string (with or without quotes)

Name of data file used. This name was defined in the data model editor or by the File description type.

<Item>: Character string (with or without quotes)

Name of item used. This name was defined in the data model editor or by the Item description type.

<New month>: Integer or character string

New month expressed in numbers (included between 1 and 12). Replaces the month in the specified date.

Remarks

Range of dates

The Date and DateTime types are used to manage the dates from 01/01/0001 to 31/12/9999.

Managing the months and years

Case 1: Direct assignment
During a direct assignment (for example, MyWork.MyDate..Month = n), the month must be included between 01 and 12. A WLanguage error occurs if an invalid month is specified.
The notation MyWork.MyDate..Month = MyWork.MyDate..Month + 5 may generate an error at run time. For example, the following code lines trigger an error:

// Code triggering the error
MyDate is Date = "20041126" // 11/26/2004
MyDate..Month = MyDate..Month + 2
// Triggers a WLanguage error because the month is equal to 13

// Correct code
MyDate is Date = "20041126" // 11/26/2004
MyDate..Month += 2

// Code triggering the error
MyDate is Date = "20041126" // 11/26/2004
MyDate1 is Date
MyDate1..Month = MyDate..Month + 2
// Triggers a WLanguage error because the month is equal to 13

// Correct code
MyDate1 = MyDate // 11/26/2004
MyDate1..Month += 2

Case 2: Operations on the months
When performing operations on the dates, the change of year is automatically managed. Therefore, if the number of months is greater than 12, the year is automatically modified and the number of months restarts from 1.
For example:

StartDate is Date = "20041226" // 12/26/2004
// Add 5 months to the date
StartDate..Month += 5 // StartDate is "20050526"

Operators available for the months

The following arithmetic operators can be used by ..Month:

++ and --
+= and - =

StartDate is Date = "20041126"
StartDate..Month++ // Add 1 month to the date
StartDate..Month += 5 // Add 5 months to the date
StartDate..Month -= 5 // Subtract 5 months from the date

Calculating the last day of the month

To find out the last day of a month, all you have to do is assign 000210 to . The last day will be automatically calculated according to the specified month.

StartDate is Date = "20041126"
StartDate..Day = 31
// November does not have 31 days
// The day is automatically replaced by 30

Calculating a payment date at 90 days (end of month)

..Day is used to calculate a payment date at 90 days (end of month).

MyDate is Date = "20041126"
MyDate..Day += 90
MyDate..Day = 31

Calculating the end of a 30-day period

A 30-day period corresponds to a one-month period from a given date. ..Month and ..Day are used to calculate the end date of a 30-day period.

StartDate is Date = "20041126"
EndDate is Date = StartDate
EndDate..Month++
EndDate..Day--

Related Examples:

Unit examples (WINDEV): Management of dates

[ + ] Using the Date type of WLanguage and the functions for handling dates.