Get DateTime Value
- 28 Nov 2022
- 1 Minute to read
- Print
- DarkLight
Get DateTime Value
- Updated on 28 Nov 2022
- 1 Minute to read
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Overview
Step Details | |
| Introduced in Version | 4.0.0 |
| Last Modified in Version | 7.12.0 |
| Location | Data > Excel and CSV |
The Get Date Time Value step helps to extract Time-Date from an excel sheet. Note that the cell format in the file should be of the date-time type, whereas the output type would be of the date-time format.
Properties
Inputs
| Property | Description | Data Type |
|---|---|---|
| Column | The specified Column for the Cell. The starting value is one. | Int32 |
| File Type | The type of file being used by the step. The step currently supports CSV, Excel_xls, or Excel_xlsx. Use Constant mapping to view the drop-down. | CsvFileType |
| Ignore First Row | Ignores the first Row in the file, typically used as a header row. | Boolean |
| Input | The Excel or CSV file where the data is pulled from. | FileData |
| Row | The specified Row for the Cell. The starting value is zero | Int32 |
| Worksheet Number | The Worksheet Number to pull the data from. The values start at zero. | Int32 |
Outputs
| Property | Description | Data Type | ||
|---|---|---|---|---|
| GetDateTimeValue1_Output | Returns the Date Time value from the specified column and row. | Date Time | ||
Related Forum Posts
Was this article helpful?
