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

this data converter will output:

1.0