Convert to Excel Date

This data converter converts the date to an Excel number that represents the same date in a spreadsheet.

Properties

The Convert to Excel Date data converter can be configured using the following properties:

Description: Type in a description to be shown in the list of data converters. If there is no type in a description, one will be generated.

Example

If the input text is

     1900-01-01 00:00:00.0

then the output text becomes:

1.0