DriveWorks Solo 22

TableSortByDate

TableSortByDate

Performs a sort on the specified column of the given table by date. The data is assumed to be in the en-US format if the culture parameter is omitted.

Syntax

TableSortByDate([Table or Table Name], [Column Index], [Has Headers], [Sort Ascending], [Culture])

Where:

Table or Table Name is a Table array (such as the data in a standard table, or the result of a QueryDataValues function).

Column is the column on which to base the sort. Number starting at 1 for the first column.

Has Headers is TRUE if the table has headers that shouldn't be included in the sort.

Sort Ascending is TRUE to sort in ascending order, FALSE to sort in descending order.

Culture (optional) is the culture code for the date format (for example fr-FR).

Examples

Example Data

The following table (DwTableSpecificationsMade)is the table required to perform the TableSortByDate on:

Data Returned As Array

The above data will be returned as an array as follows:

{"ID", "State Name", "Project Name", "Date"; "1", "Specify", "Default", "01/14/2018"; "7", "Saved", "Project1", "02/15/2018"; "8", "Awaiting Review", "Project1", "03/16/2018"; "4", "Released To Server", "Default", "04/17/2018"; "5", "Saved", "Default", "05/18/2018"; "6", "Specify", "Project1", "06/19/2018"; "2", "Pending", "Default", "07/20/2018"; "3", "Completed", "Default", "08/21/2018"; "9", "Changes Requested", "Project1", "09/22/2018"}

Array Expressed in a Table (such as a Data Table control)

Culture Codes

The table below gives an example of some of the more common Culture Codes.

For a more comprehensive list use your Internet search engine to search the term .net framework culture code.

See also

How To: Work With Arrays