ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

Date and Time functions
List of functions for managing dates and times
The Date input field: Input or display masks
WINDEV, WINDEV Mobile and WEBDEV propose two types of masks...
<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.
<Source>.StatDate (Function)
Returns the date of the last update for the index statistics.
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.
DateToDayOfWeek (Function)
Returns the day of the week that corresponds to a given date.
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).
DayOfYearToDate (Function)
Takes the number of a day in the year and returns the corresponding date in "YYYYMMDD" format.
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...
SchedulerDateVisible (Function)
Makes a day visible or invisible in a Scheduler control.
DeleteParameter (Function)
... the persistence of data in the controls.
fCacheDir (Function)
Returns the path of directory that will be used to store the data in cache on the internal storage...
HExportXLS (Function)
Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX).
HExportCSV (Function)
Exports the records found in a data file (HFSQL or OLE DB), a view or a query to a CSV file.
HTransaction (Function)
Starts a transaction on the data files (HFSQL or accessed via a Native Connector) and creates...
ProcedureTrace (Property)
... the headers and data sent.
<Spreadsheet>.DeleteAll (Function)
Deletes the entire data from a Spreadsheet control found in a window (cells, formulas, size...
<Source>.RecNum (Function)
Returns: the number of the current record in the HFSQL data file. the number of the current...
<Source>.ExportCSV (Function)
Exports the records found in a data file (HFSQL or OLE DB), a view or a query to a CSV file.
<Source>.ExportJSON (Function)
Exports the records found in a data file (HFSQL or OLE DB), view or query to a JSON file.
<Source>.ExportXLS (Function)
Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX).
SysCacheExternalStorage (Function)
Returns the path of directory that will be used to store the data in cache on the external storage...
MmoEncryption (Property)
... with the data file.
NdxEncryption (Property)
... associated with the data file.
HRecNum (Function)
Returns: the number of the current record in the HFSQL data file. the number of the current...
HTransactionStart (Function)
Starts a transaction on the data files (HFSQL or accessed via a Native Connector) and creates...
<Connection variable>.Transaction (Function)
Starts a transaction on the data files (HFSQL or accessed via Native Access) and creates...
<Connection variable>.TransactionStart (Function)
Starts a transaction on the data files (HFSQL or accessed via Native Access) and creates...
<Source>.ExportXML (Function)
Exports the records found in a data file (HFSQL or OLE DB), view or query to an XML file.
HExportXML (Function)
Exports the records found in a data file (HFSQL or OLE DB), view or query to an XML file.
CurrentMonth (Function)
Returns the number of the current month.
FirstDayOfMonth (Function)
Returns the first day of the month.
The Table control
or coming from a data file, a view or a query......