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
Returns the date of the first day of the year.
Versions 22 and later
WINDEVJava This function is now available for the Java applications.
New in version 22
WINDEVJava This function is now available for the Java applications.
WINDEVJava This function is now available for the Java applications.
Example
// Displays the customers created since the beginning of the year
HReadFirst(Customer, Name)
WHILE HOut() = False
// Process the record
IF (Customer.CreationDate >= FirstDayOfYear()) THEN
Trace(Customer.Name)
END
HReadNext(Customer, Name)
END
Syntax

Finding out the first day of the year from a date Hide the details

<Result> = FirstDayOfYear([<Date>])
<Result>: Character string or Date variable
First day of the year (in YYYYMMDD format) for the specified date.
<Date>: Optional character string, Date or DateTime variable
Date for which the first 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).
  • 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 first day of the year from a year Hide the details

<Result> = FirstDayOfYear(<Year>)
<Result>: Character string or Date variable
First day of the year (in YYYYMMDD format).
<Year>: Integer
Year for which the first day is sought.
Remarks
This function is used to easily calculate ranges of dates.
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 21
This page is also available for…
Comments
Click [Add] to post a comment