PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
LastDayOfMonth (Function)
In french: DernierJourDuMois
Returns the date of the last day for the specified month.
Versions 17 and later
iPhone/iPad This function is now available for iPhone/iPad applications.
Android This function is now available for Android applications.
WINDEVJava This function is now available for the Java applications.
New in version 17
iPhone/iPad This function is now available for iPhone/iPad applications.
Android This function is now available for Android applications.
WINDEVJava This function is now available for the Java applications.
iPhone/iPad This function is now available for iPhone/iPad applications.
Android This function is now available for Android applications.
WINDEVJava This function is now available for the Java applications.
Versions 18 and later
Android Widget This function is now available in Android Widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Android Widget This function is now available in Android Widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Android Widget This function is now available in Android Widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Versions 20 and later
Universal Windows 10 App This function is now available for Windows Phone applications.
New in version 20
Universal Windows 10 App This function is now available for Windows Phone applications.
Universal Windows 10 App This function is now available for Windows Phone applications.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Versions 22 and later
WEBDEV - Server codePHP This function is now available for the PHP sites.
New in version 22
WEBDEV - Server codePHP This function is now available for the PHP sites.
WEBDEV - Server codePHP This function is now available for the PHP sites.
Example
// Returns the last day for the month of February 2017
MyDate is Date
MyDate = LastDayOfMonth(2017, 2)
// Returns the last day of the current month
MyDate is Date
MyDate = LastDayOfMonth()
Syntax

Finding out the last day of the month from a date Hide the details

<Result> = LastDayOfMonth([<Date>])
<Result>: Character string or Date variable
Date corresponding to the last day of the specified month (in YYYYMMDD format).
<Date>: Optional character string, Date or DateTime variable
Date for which the last day of the month must be calculated. This date can correspond to:
  • a character string in YYYYMMDD format (YYYY corresponds to the year, MM to the month and DD to the day).
  • Versions 24 and later
    a character string in YYYYMMDDHHMMSSCC format (YYYY corresponds to year, MM to month, DD to day, HH to hour, MM to minutes, SS to seconds and CC to hundredths of a second (use CCC for milliseconds). In this case, only the date is taken into account.
    New in version 24
    a character string in YYYYMMDDHHMMSSCC format (YYYY corresponds to year, MM to month, DD to day, HH to hour, MM to minutes, SS to seconds and CC to hundredths of a second (use CCC for milliseconds). In this case, only the date is taken into account.
    a character string in YYYYMMDDHHMMSSCC format (YYYY corresponds to year, MM to month, DD to day, HH to hour, MM to minutes, SS to seconds and CC to hundredths of a second (use CCC for milliseconds). In this case, only the date is taken into account.
  • a Date variable.
  • Versions 24 and later
    a DateTime variable. In this case, only the date is taken into account.
    New in version 24
    a DateTime variable. In this case, only the date is taken into account.
    a DateTime variable. In this case, only the date is taken into account.
If this parameter is not specified, today's date is used by default.

Finding out the last day of the month from a year and a month Hide the details

<Result> = LastDayOfMonth(<Year> , <Month>)
<Result>: Character string or Date variable
Date corresponding to the last day of the specified month.
<Year>: Integer
Year for which the last day of the month must be calculated.
<Month>: Integer
Month for which the last day must be calculated.
Related Examples:
Management of dates Unit examples (WINDEV): Management of dates
[ + ] Using the Date type of WLanguage and the functions for handling dates.
Component : wd240std.dll
Minimum version required
  • Version 16
This page is also available for…
Comments
Video Sobre LastDayOfMonth
https://youtu.be/kStyPaWke_0
amarildo
26 Oct. 2018
Exemplo Pegar ultimo dia do mes
Exemplo Pegar ultimo dia do mes

d_data is Date=EDT_data
d_minha_data is Date=""
d_minha_data=LastDayOfMonth(d_data)
EDT_ultimoDia=d_minha_data..Day

//Blog com video e exemplo
http://windevdesenvolvimento.blogspot.com.br/2016/07/curso-windev-datas-007-lastdayofmonth.html
https://www.youtube.com/watch?v=b89iE1imKHg
De matos AMARILDO
22 Jul. 2016