Home
Reference Guide
This guide describes conceptual information about data design environment components when you want to use the data fabrication feature in HCL OneTest™ Server.
Schema design
A schema is a graphical data dictionary that contains metadata definitions of the structure of a document to generate test data. Schema provides visual cues for understanding the structure and complete definition of an object.
Functions and expressions
Date/time functions
TEXTTODATE

Reference Guide
This guide describes conceptual information about data design environment components when you want to use the data fabrication feature in HCL OneTest™ Server.
- Files
  You add a file to a project to use it as input in the project. You can upload a file from your local file system to a project from the Files tab to generate test data. Alternatively, you can upload it when you define an action.
- Connections
  A connection defines the properties that are required to connect to an external resource. An action uses a connection to provide source data to a project or write data from a source to a target. Multiple actions can use the same connection. You can define both connections and actions at the project level.
- Schema design
  A schema is a graphical data dictionary that contains metadata definitions of the structure of a document to generate test data. Schema provides visual cues for understanding the structure and complete definition of an object.
  - Introduction to schema design
    Use the Schemas tab to define, modify, and view schemas. A schema describes the syntax, structure, and semantics of your data.
  - Type properties
    The properties of a type define the characteristics of the data objects of that type.
  - Item restrictions
    Item restrictions are an optional feature you can use to specify valid or invalid data objects for an item type. Item restrictions are grouped into three categories: Value, Character, and Range.
  - Components
  - Partitioning
  - Type inheritance
  - Schema analyzer
  - Distinguishable objects
  - Functions and expressions

TEXTTODATE

The TEXTTODATE function converts text item from CCYYMMDD or YYMMDD format to a date.

You can use the TEXTTODATE to convert a text item to a date, however, the TODATETIME function provides greater flexibility for specifying the resulting date-time format .

Syntax:: TEXTTODATE ( single-text-expression )
Meaning:: TEXTTODATE ( text_to_convert_to_date )
Returns:: A single date

The text_to_convert_to_date must be in either CCYYMMDD or YYMMDD format. If the text_to_convert_to_date is in error (for example, it is not a valid date), the result is "none".

If text_to_convert_to_date is in YYMMDD format and is being assigned to a date format that includes a century, the century is determined based on the century run option setting using the CCLookup parameter or the current century.

Examples

TEXTTODATE ( "990114" )
Returns a single date item with the value of January 14 in the year 99
TEXTTODATE ( OrderDate )
Returns OrderDate as a single date item.

Related functions


DATETOTEXT	TEXTTOTIME
NUMBERTOTEXT	TIMETOTEXT
TEXTTONUMBER	TODATETIME