ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

Date and Time functions
List of functions for managing dates and times
<ftpConnection variable>.Date (Function)
Returns the different dates of a file (date the file was created, modified or accessed) located on an FTP server (File Transfer Protocol).
This new function is available from WINDEV Suite SaaS 2025 - Update 2.
The Date input field: Input or display masks
WINDEV, WINDEV Mobile and WEBDEV propose two types of masks...
<Source>.StatDate (Function)
Returns the date of the last update for the index statistics.
SchedulerDateVisible (Function)
Makes a day visible or invisible in a Scheduler control.
The formatted display control
This control can be used to display dates, times and monetary values for example, respecting the corresponding display format...
<Organizer>.DateVisible (Function)
Makes a day visible or invisible in an Organizer control.
DateToDayOfYear (Function)
Returns the day of the year corresponding to a given date.
WeekToDate (Function)
Returns the date of the Monday for the specified week and year.
FirstDayOfYear (Function)
Returns the date of the first day of the year.
LastDayOfMonth (Function)
Returns the date of the last day for the specified month.
OrganizerDateVisible (Function)
Makes a day visible or invisible in an Organizer control.
<Source>.RecordDate (Function)
Returns the date and time of last write operation performed on a record in an HFSQL data file (Classic or Client/Server).
DateToDayOfWeek (Function)
Returns the day of the week that corresponds to a given date.
MonthNumberInAlpha (Function)
Returns the name of the month according to its number.
Functions for managing Dates and Times (prefix syntax)
List of functions for managing dates and times
<Scheduler>.DateVisible (Function)
Makes a day visible or invisible in a Scheduler control.
HRecordDate (Function)
Returns the date and time of last write operation performed on a record in an HFSQL data file (Classic or Client/Server).
HStatDate (Function)
Returns the date of the last update for the index statistics.
DatePicker (Function)
Opens the system date picker.
Analysis editor: the different types of sections
The different types of items proposed in the data model editor are as follows:
DayNumberInAlpha (Function)
Returns the name of the day of the week according to its number.
DateToDay (Function)
Returns the day corresponding to a given date.
Edit control
The Edit control allows users to enter data...
DayOfYearToDate (Function)
Takes the number of a day in the year and returns the corresponding date in "YYYYMMDD" format.
OrganizerDisplay (Function)
Reinitializes the content of an Organizer control from its data source (HFSQL data file...
TimelineDisplay (Function)
Reinitializes the content of a TimeLine control from its data source (HFSQL data file for example).
OrganizerSelectedRange (Function)
Returns the start or end date and time of the time slot selected in an Organizer control.
SchedulerSelectedRange (Function)
Returns the start or end date and time of the time slot selected in a Scheduler control.
<TimeLine>.Display (Function)
Reinitializes the content of a TimeLine control from its data source (HFSQL data file for example).
<Organizer>.SelectedRange (Function)
Returns the start or end date and time of the time slot selected in an Organizer control.
<Organizer>.Display (Function)
Reinitializes the content of an Organizer control from its data source (HFSQL data file...
<Source>.InfoLock (Function)
Returns information about the lock set on a data file, on one or all the records in a data file.
HInfoLock (Function)
Returns information about the lock set on a data file, on one or all the records in a data file.
<Connection>.InfoLock (Function)
Returns information about the lock set on a data file, on one or all the records in a data file.
The log process
... over a given period of time (date the file was created, last automatic data modification, last backup created...
Type (Property)
The Type property is used to get: the type of element (data file or item) defined...
Key and referential integrity
In an analysis, the "Key" items are also used to manage the consistency of data (called referential...
<Organization Chart>.Display (Function)
Reinitializes the content of an Organization Chart control from its data source (HFSQL data file...
<Table>.End (Function)
Stops the manual iteration of data file linked to a Table control based on a data file.
<Source>.DeclareExternal (Function)
Temporarily imports into the current analysis the description of a data file from an existing HFSQL...
OrgDisplay (Function)
Reinitializes the content of an Organization Chart control from its data source (HFSQL data file...
<Source>.Flush (Function)
Forces the operating system of the computer where the data files are found to write data onto...
TableEnd (Function)
Stops the manual iteration of data file linked to a Table control based on a data file.
fTime (Function)
Returns or modifies the different times associated with a file or directory (date created, modified...
HFlush (Function)
Forces the operating system of the computer where the data files are found to write data onto...
HDeclareExternal (Function)
Temporarily imports into the current analysis the description of a data file from an existing HFSQL...
DateTimeLocalToUTC (Function)
Converts a local date and time (time zone, summer time, winter time) to UTC.
7. HFSQL: files physically created