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
NUMBERTODATE

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

NUMBERTODATE

You can use the NUMBERTODATE function to perform a calculation on a date.

NUMBERTODATE converts an integer to a date, where the integer is the number of days from December 31, 1864, to the specified date. Only positive, non-zero values can be specified as valid parameters.

.

Syntax:: NUMBERTODATE (single-integer-expression)
Meaning:: NUMBERTODATE (integer_to_convert)
Returns:: A single date

After converting an integer to a date, if the result is being assigned to a date object, the resulting date is in the presentation for that output. If the resulting date is not being assigned to an object, it has a CCYYMMDD presentation.

When the year exceeds four digits, the output will display hash characters (#) for the CCYY values because the field is defined to be only four digits in length.

Examples

NUMBERTODATE (StartDate)
This example converts the StartDate value from an integer to a date that is in CCYYMMDD format.

Related functions

ADDDAYS
DATETONUMBER
FROMDATETIME
TODATETIME