ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Standard functions / Date and time functions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Returns the date of the last day of the year.
Example
dateSubscription is Date = "20190125"
// Determine the last day of the year
dateEndOfYear is Date = LastDayOfYear(dateSubscription)
 
 
nNumberDaysBeforeEndOfYear is int
// Calculate the number of days between January 25 2019 and the end of the year 2019 (December 31)
nNumberDaysBeforeEndOfYear = DateDifference(dateSubscription, dateEndOfYear)
Syntax

Getting the last day of the year based on a date Hide the details

<Result> = LastDayOfYear([<Date>])
<Result>: Character string
Last day of the year (YYYYYMMDD) for the specified date.
<Date>: Optional character string, Date or DateTime variable
Date for which the last day of the year 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).
  • a character string in YYYYMMDDHHmmSSCC format (YYYY corresponds to the year, MM to the month, DD to the day, HH to hours, mm to minutes, SS to seconds and CC to hundredths of a second (use CCC for thousandths of a second)). In this case, only the date is taken into account.
  • a Date variable.
  • a DateTime variable. In this case, only the date is taken into account.
If this parameter is not specified, the current date is used by default.

Finding out the last day of the year based on a year Hide the details

<Result> = LastDayOfYear(<Year>)
<Result>: Character string or Date variable
Last day of the year (YYYYYMMDD).
<Year>: Integer
Year for which the last day must be calculated.
Remarks
This function is used to easily calculate date ranges.
Component: wd290std.dll
Minimum version required
  • Version 26
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help